where clause without single quote in set?

Question

I have a set statement. I am trying to add a where statement inside that. However, when I put a single quote, it is not executing. How to escape the single quote in where clause to execute the set statement? Below is my code:

DECLARE @desttablename NVARCHAR(MAX)
SET @desttablename = 'select distinct desttablename 
from #table_norm 
where desttablename = 'Screener''

tried this SET @desttablename = 'select distinct desttablename from #table_norm where desttablename = ''screener''' Got an error: Incorrect syntax near the keyword 'distinct'. — Sriram NR, Sep 24 '22 at 17:59
Try simply doing a select on your string first. That will show you what you are getting — Jonathan Willcock, Sep 24 '22 at 17:59
@JonathanWillcock tried with double single quotes but the error is Incorrect syntax near 'screener'. — Sriram NR, Sep 24 '22 at 18:07
Use a parameter and the embedded apostrophe delimiters are eliminated. — June7, Sep 24 '22 at 18:24
In your query it will break so alternatively you can double the single quote to fix the issue, try something like `SET @desttablename = 'select distinct desttablename from #table_norm where desttablename = '+'''Screener'''+'' ` — Amal Ps, Sep 25 '22 at 14:47

score 0 · Answer 1 · answered Sep 24 '22 at 18:26

0

I found an alternative way to do this:

select @desttablename = (select distinct desttablename from #table_norm where 
desttablename = 'Screener')

answered Sep 24 '22 at 18:26

Sriram NR

41
5

where clause without single quote in set?

1 Answers1