Page 1 of 1

# question

Posted: Wed Feb 09, 2005 6:10 pm
by jkj2001
I have a varchar(25) character with values like this:

0021
0023
0034
.
.
.


When I run a search that says "select MYFIELD from mytable where MYFIELD like '#25'" I get all sorts of strange hits returned-- the 0031, for instance.

Why is that, and how can I restrict things so only the 0025s return? We're on version 4.04.1067366033 of Texis.

thanks!

# question

Posted: Wed Feb 09, 2005 9:49 pm
by mark
Leading 0 indicates octal. Octal 31==Decimal 25