SQL query..building a string !

[fixthebug2003]

Hi,
I need a SQL which looks like this:

SELECT X,Y,Z FROM TABLE1 WHERE
TABLE1.NAME in (@variable1)

Now, this @variable1 should have values like this
'name1','name2','name3' that needs to be built (can have hard-coded values too)
so that the SQL query can execute...But how can I build this @variable1 in SQL Server 2000

thanks
Fixthebug2003

 

[dellyjm]

declare @sql varchar(1000)

-- sure this will be parameter
declare @variable1 varchar(10)

select @sql = 'SELECT X,Y,Z FROM TABLE1 '
select @sql = @sql + 'WHERE TABLE1.NAME in '
select @sql = @sql + @variable1

execute (@sql)

Delton

Not sure if this is what u want

 

[fixthebug2003]

I guess you did not get my question.
My question is: how to build a string with quotes in them?

 

[jby1]

Use a single quote twice to get a quote within a string

eg:

declare @variable varchar(100)

select @variable = '''hardcodedstring'''

select @variable

output will be:
'hardcoded string'