Results 1 to 2 of 2

Thread: seeking help in LIKE / MATCHES in IBM informix sql

  1. #1
    Join Date
    Aug 2021
    Posts
    2

    seeking help in LIKE / MATCHES in IBM informix sql

    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

  2. #2
    Join Date
    Aug 2021
    Posts
    2
    correction

    Hi all

    I am new to IBM Informix ,

    select * from TEST_TABLE where c2 like '5 %';

    below are the results returned,

    c2 5


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •