Subject | Re: [firebird-support] Re: Help with strange answer in WHERE clause |
---|---|
Author | Ann W. Harrison |
Post date | 2004-05-03T21:49:31Z |
At 05:28 PM 5/3/2004, hcarvajalsy wrote:
like this:
00023
00100
00999
01000
Regards,
Ann
>Thank you. The problem is that the field might also have letters, soThe alternative is to store your numbers padded on the left with zeros,
>I will have to use a single comparison instead of a range.
like this:
00023
00100
00999
01000
Regards,
Ann