Hi,

I use the LIKE statement to provide searching capabilities. When a
user enters a SINGLE white space character (because he wants to search
for all strings including at least one white space character), this
translates into this statement: LIKE '% %'

Note that the SINGLE white space character appears between the two %
wildcard characters. Unfortunately the result set contains all
records, not only those having a white space character. It appears
that the engine ignores the single withspace character, and thus LIKE
'% %' translates to LIKE '%' for the engine.

I also tried to escape the space character but this didn't work either.

How can this be done?

Bruno