Post reply

Search for data containing embedded blanks

  • August 8, 2007 at 10:04 am

    #174775

    I have a script set-up and searches for fields that are basic text are fine but as soon as I choose a field which is a drop-down combo box the blanks in the data are replaced with "__b". A search finds nothing.

    Can anyone help

  • August 9, 2007 at 2:08 am

    #725634

    I'm not sure if I understand your issue exactly, but one possible cause could be that the "_" is a wildcard for the LIKE expressions. If you try to find text using

    WHERE somecolumn LIKE '__a'

    the underscores indicate any single character. So this would match 'aaa', '__a', 'bba', etc. If you want to match "_" you will need to escape it. One way to do this is:

    WHERE somecolumn LIKE '[_][_]a'

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply