How do I compare blank spaces in a string using LIKE ?
I tried the following:
SELECT * FROM table WHERE name LIKE '% John %';
But it didn't work.
To explain: I don't want the string 'Johnson' to be shown when running the query
above.
Thanks.
Nelson Azambuja Jr.
Analista de Sistemas
--------------------------------------------------------------------------------
