Subject Re: [firebird-support] Re: Help with strange answer in WHERE clause
Author Ann W. Harrison
At 05:28 PM 5/3/2004, hcarvajalsy wrote:
>Thank you. The problem is that the field might also have letters, so
>I will have to use a single comparison instead of a range.


The alternative is to store your numbers padded on the left with zeros,
like this:

00023
00100
00999
01000

Regards,


Ann