Like operator showing ERROR on SQL variable

Question

declare @schoolName varchar(max) = 'children's Garden'

select * from schools where Schoolname like @schoolName+'%'

This is my SQL query. When I store a string with an apostrophe there is error. How can I overcome this?

The variable @schoolName is coming from the code.

To use a single quote within and SQL string, double it. – Dale K Jan 14 '20 at 08:31 — Dale K, Jan 14 '20 at 08:31

score 4 · Answer 1 · answered Jan 14 '20 at 08:31

4

Use double apostrophes to make it valid SQL String :

declare @schoolName varchar(max) = 'children''s Garden'

select s.* 
from schools s 
where s.Schoolname like @schoolName + '%'

answered Jan 14 '20 at 08:31

Yogesh Sharma

1

The variable comes from the code. – ReaL_HyDRA Jan 14 '20 at 08:42
1

split the incoming variable at the point of " ' " in the code. – ReaL_HyDRA Jan 15 '20 at 10:08

1 Answers1