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