soo redicilous prob with escape charachters

the problem is i wanna make this piece of code work and i don know what the problem is , i think it's with the combination of charachters ' and "

Code:

set @query=@query+ "cast(ID as varchar) like'%'+ltrim(@id)+'%' " 
set @query=@query+ @option+" userName like'%'+ltrim(@name)+'%' "
set @query=@query+ @option+" cast(referrer as varchar) like'%'+ltrim(@ref)+'%' "
set @query=@query+ @option+" age=cast(@age as int) "
exec(@query)

 

That looks scary!

 

Try this query,

Code:

set @query=@query+ 'cast(ID as varchar) like ''%'+ltrim(@id)+'%'''
set @query=@query+ @option+' userName like ''%' +ltrim(@name)+'%'''
set @query=@query+ @option+' cast(referrer as varchar) like ''%'+ltrim(@ref)+'%'''
set @query=@query+ @option+' age=cast(@age as int) '