Hi all
I am new to IBM Informix ,
select * from TEST_TABLE where c2 like '5 %';
below are the results returned,
c1 ABC
c2 5
c1 FGH
c2 5 ½
I am concerned about the row c2 5 why is it returning 5 when I am looking for 5<space>%
Note: c2 is a varchar and it did not have any trailing spaces.
Can anyone let me know the reason of this wierdness...
Thank you so much