VSQL - Numeric values with more than 1 digit aren't found if beginning with zeroes

[Ruslan Zasukhin]

On 6/16/08 11:51 AM, "Ernesto Giannotta" <ernestogiannotta at tiscalinet.it>
wrote:

Hi Erne,

Thank you for Mantis report.
 
> I've made some test and found that a query like this:
> 
> Select RecID, * from TestBo Where UlongTest = 01
> 
> works fine
> 
> but this:
> 
> Select RecID, * from TestBo Where UlongTest = 011
> 
> does not work!
> 
> I've tested this with ULong, ULLong and UShort fields, all same
> behaviour
> 
> In other words if the searched value is more than 1 digit trailing 0's
> are no more ignored by the SQL parser.
> 
> 
> I'll submit this to Mantis

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]