replace function does not work in dynamic sql query

Question

I am facing an problem in replacing the character in sql query. I am using vs 2008. I am trying to replace the Turkish character İ to I.

Works fine:

Select FirstName, REPLACE(FirstName,N'İ','I') replaced 
from Employee where FirstName = N'İAİL'

Fails when used as dynamic statement.

Same query fails to replace in dynamic statement.

DECLARE @SQL NVARCHAR(4000)
SET @SQL = 'Select FirstName, REPLACE(FirstName,N''İ'',''I'') replaced from Employee where FirstName = N'İAİL'
EXEC (@SQL)

Can you let me know why this fails in second condition?

Peter Tirrell · Accepted Answer · 2013-11-20 20:59:27Z

2

Copying and pasting into SSMS the syntax highlighting showed you're missing some apostrophes on the end of your statement:

DECLARE @SQL NVARCHAR(4000)
SET @SQL = 'Select FirstName, REPLACE(FirstName,N''İ'',''I'') replaced from Employee where FirstName = N''İAİL'''
EXEC (@SQL)

Dynamic SQL like that with lots of strings is a royal PITA.

answered Nov 20, 2013 at 20:59

Peter Tirrell

3,0134 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

replace function does not work in dynamic sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related