On 12 Sep 2003 at 8:39, Nelson Azambuja Jr. wrote:
> I tried the following:
>
> SELECT * FROM table WHERE name LIKE '% John %';
>
> But it didn't work.
Please explain what didn't work. What were you expecting to happen,
and what actually happened?
> To explain: I don't want th
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.
