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

[Ernesto Giannotta]

Hi Ruslan,

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


Cool Runnings,
Erne.