quotation mark 2

[wg26]

Hi Everyone:

I am trying to put a quotation mark on a variable, and I did as the following:
@SQL = 'select ....from....
where [Detail].[Detail Name] = ' + ''' + @DetailName + '''

but it does not work. and Can one please kindly tell me how to put quotation mark around a variable? thanks alot

 

[mwolf00]

I think this will work....

@SQL = 'select ....from....
where [Detail].[Detail Name] = ''' + @DetailName + '''' Get the Best Answers! faq333-2924
"A witty saying proves nothing." - Voltaire
mikewolf@tst-us.com

 

[sunila7]

Hi,

Try this


declare @SQL varchar(2000)
declare @detailname varchar(100)

set @detailname ='gg'

set @SQL = 'select * from tbl
where [Detail].[Detail Name] = ''' + @DetailName + ''''

print @sql



Sunil

 

[TheBugSlayer]

Function QUOTENAME should work. If not try playing around with SET QUOTED_IDENTIFIER ON/OFF so you can use double quotes.
Good luck.