if...in the where clause

[sexydog]

where
if @choice = 'province' then
@province in (select province_name
from p_provinces
where @province..........


how can i do this

 

[linda105]

Since you are passing in parameters then maybe it is a stored procedure that you are running?

If so you could construct your sql statement in code based on the inputs

declare @sqlString as varchar(255)
...
select @sqlString = @sqlString + @sqlwhere
...
EXEC master.dbo.sp_SQLEXEC @sqlString

 

[Strannik]

Try the following construction:

WHERE
Case
WHEN @Choice = 'province' THEN (SELECT 1 FROM p_provinces where @province ...)
ELSE 0
END is Not Null

 

[tlbroadbent]

How about this?

If @choice = 'province'
Begin
If Exists
(Select * From p_provinces
Where Province=@province)
Begin
<Province found code>
End
Else
Begin
<Province not found code>
End
End
Else
Begin
<@choice <> 'Province' code>
End
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.