Re: Tricky SQL

Article View: borland.public.interbase.sql

Article #10981

Back to borland.public.interbase.sql Previous Next

#10981

From: Wayne Niddery [TeamB]
Date: Thu, 02 Jan 2003 05:31

25 lines
2135 bytes

"Ronny Bengtsson" <Ronny_Bengtsson@hotmail.com> wrote in message
news:Xns92F6EC38DAE0Cronnybengtssonrobese@207.105.83.65...
>
> I have a database with documents of modifications that could affect
> different part numbers that I have in my inventory.
>
> The issuer of the document could say the the modification will affect a
> range of partnumbers
> i.e. 123-4567 to 123-4599
>
> I want to check my inventory database if I have partnumbers within this
> range.
> But the partnumbers in the inventory database could be previous entered
> and saved in different ways i.e. 123/4567, 123-4568, 123 4590 etc.

The best thing I can suggest to you is to define a normalization for the
consistent storage of those numbers no matter what the user may enter.
Trying to handle inconsistent formats within an SQL statement is bound to be
very painful.


--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman

Technical Details

Message-ID: <3e13cf70$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65> <3e131ffe$1@newsgroups.borland.com> <Xns92F6EC38DAE0Cronnybengtssonrobese@207.105.83.65>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,99de7b04b7abe7f7
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-01 21:39:22 PST
From: "Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <Xns92F69DA62D2AFronnybengtssonrobese@207.105.83.65> <3e131ffe$1@newsgroups.borland.com> <Xns92F6EC38DAE0Cronnybengtssonrobese@207.105.83.65>
Subject: Re: Tricky SQL
Date: Thu, 2 Jan 2003 00:31:54 -0500
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.50.82.158
Message-ID: <3e13cf70$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1041485680 209.50.82.158 (1 Jan 2003 21:34:40 -0800)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message