# question

Post Reply
jkj2001
Posts: 142
Joined: Fri Mar 29, 2002 1:39 pm

# question

Post 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!
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

# question

Post by mark »

Leading 0 indicates octal. Octal 31==Decimal 25
Post Reply