T-SQL

Lost User

why there is a syntax error on 2 ? 1 . set @sql = @sql + N' and (summary like ''%' + @keywords + '%'')' 2 . set @sql = @sql + N' and (summary like ' + '%' + @keywords + '%' + ')'

StylezHouse

I don't see a syntax error, but in number 2, @keywords isn't single quoted... your query will look something like... and (summary like '%somevalue%') and (summary like %somevalue%)

Alsvha

I would guess it is because the '' in line 1 isn't a quotation mark, but double pings ' which means escaping the second ping. Ping normally starts a string, but if you need pings in the string, you must escape them by adding a ping infront. Thus the string isnt' terminated proberly in line 2. I'd think something along that line? --------------------------- 127.0.0.1 - Sweet 127.0.0.1

Mattias Olgerfelt

Hi there... this is the problem... U have to have an apostorph after like an you dont... so change the code to: set @sql = @sql + N' and (summary like ''' + '%' + @keywords + '%' + ''')' /M

Colin Angus Mackay

Alsvha wrote: pings :confused: You mean "apostrophe"

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Alsvha

ahh - yeah. I've always myself used and heard ' refered to as a ping when used in code - but yes - it is an apostorphe in english :o sorry - habbits die hard :D --------------------------- 127.0.0.1 - Sweet 127.0.0.1