SQL 'LIKE' clause with apostrophe

Question

If im trying to search for 'RYAN'S TEAM' in sql it doesnt like the fact that i have an apostrophe ' in RYAN'S and detects that as the end of the LIKE statement.

    [Team] LIKE '%RYAN'S TEAM%'

It recognises the whole next line as red in sql server. Is there anyway around this as RYAN'S TEAM is the way it is stored in the database.

You can escape it with another quote. Like this: `[Team] LIKE '%RYAN''S TEAM%'` — Rigerta, Sep 20 '17 at 08:32

score 5 · Accepted Answer · answered Sep 20 '17 at 08:32

5

This will work:

 [Team] LIKE '%RYAN''S TEAM%'

You just have to double the quote chars.

answered Sep 20 '17 at 08:32

sandrooco

8,016
9
48
86

SQL 'LIKE' clause with apostrophe

1 Answers1