-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Thej
Message 11 in Discussion
Hi,
Here is one possible solution to your
problem
Select * from tablename where
cast(replace(value ,',','') as int) = cast(replace('32,43,56,57',',','') as int).
Hope this helps.
-Thejus
-----Original Message-----
From: raja_blr
[mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 3:00
PM
To: BDOTNET
Subject: Re: PLS HELP IT IS VERY
URGENT..................
New Message on BDOTNET
PLS HELP
IT IS VERY URGENT..................
Reply
Reply to Sender Recommend
Message 5 in
Discussion
From: raja_blr
Here is one solution.
If u can add comma ( , ) like this for eg ,32,43,56,57, or any other
special chars
say $,& ,it will be simple.
Iterate through all value from user
check for 32,56,57,45 .
For ,45, Select * from table1 where col1 like '%,45,%' will return
zero record,then
just insert.
-Raja
View other groups in this
category.
-----------------------------------------------------------
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]
