Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-01 : 18:24:12
|
kaushik writes "I have a problem with in clause
When i write a sql statement as
select * from city where Name in('Bombay','Delhi')
It's works properly and returns correct number of rows
but if i do something like following
Declare @var1 varchar(50)
select @var1 = 'Bombay' + "," + 'Delhi'
select * from city where Name in(var1)
This does not work. What is the problem, y does this not work and what is the solution
Thank u" |
|
|
|
|
|
In clause