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