SQL Server

#1 (**permalink**) 04-07-2008, 05:14 PM

Can u plz solve the below mentioned query.

use pubs
declare @String varchar(100)
set @String = '''CA'',''KS'',''TN'',''OR'''

print @String

select * from dbo.authors where state in (@String )

The select statement is no displaying data. Where as when we print the value of @String, it willcome correct, but with select statement it is not working.
Plz resolve this for me.

SandeshSegu · #2 (**permalink**) 08-26-2008, 10:12 AM

Hi,
Please use the below Query...

Quote:

use pubs
declare @String varchar(100)
Declare @SQL varchar(200)
set @String = '''CA'',''KS'',''TN'',''OR'''

Set @SQL= 'select * from dbo.authors where state in ('+@String + ')'
Print @SQL
exec (@SQL)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

SQL Server

ANSWER(S):