-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SriSamp
Message 4 in Discussion
IN will not work in this case, because '1,2,3' will be interpreted as a literal
character string and your comparision will give an error. There are two ways you can
solve this: (1) Use dynamic SQL so that you construct your query inside a string and
then use the EXEC command. (2) Use a function like CHARINDEX to search through the
input parameter. Here are examples for both approaches: (1) DECLARE @sqlString
VARCHAR(8000)
DECLARE @pattern VARCHAR(50)
SET @pattern = '0, 1'
SET @sqlString = 'SELECT * FROM authors WHERE contract IN (' + @pattern + ')'
EXEC (@sqlString)
(2) DECLARE @sqlString VARCHAR(8000)
DECLARE @pattern VARCHAR(50)
SET @pattern = ',0,1,'
SELECT * FROM authors WHERE CHARINDEX (',' + CAST(contract AS VARCHAR(1)) + ',',
@pattern) > 0 HTH, Srinivas Sampath MVP - SQL Server
http://www32.brinkster.com/srisamp
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
