-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Thej
Message 7 in Discussion
Hi Srinivas,
I am sorry, understood ur question wrongly first time.Srinivas thanks for correcting
me.
Yeah since the number can be of any order, yup then the only option is to split using
the patindex and loop thru the string.
Here is one of the logic....using cursors..
declare @Value varchar(20)
declare @tmpVar varchar(10)
select @Value = '32,43,56,57'
while len(@Value) > 0
begin
select @tmpVar = substring(@Value ,1,patindex('%,%',@Value)-1)
---here u will get all ur values in @tmpVar like 32 , 43 , 56 and 57 where u can use
it to for select statments
select @Value= substring(@Value,patindex('%,%',@Value)+1,len(@Value))
end
Hope i have got ur problem this time...
-thejus
-----------------------------------------------------------
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]
