[V4RB 0003228]: SQL - Numeric values with more than 1 digit aren't found if beginning with zeroes

[Ruslan Zasukhin]

On 8/19/08 9:07 AM, "Ernesto Giannotta" <ernestogiannotta at tiscalinet.it>
wrote:

Hi Erne

> Hi Ivan,
> 
> how so?
> 
> literals beginning with a 0 are treated as octals?

Yes, like in C/C++ and e.g. MySQL.

> Is this documented Sql standard?

Yes

> What if I should want it as an hex?

HEX is   Ox125F
 

-- 
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]