----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Manoj-despot Message 9 in Discussion Hi Balaji Try this query, check the syntax though 1. As already submitted by Tej use substring to split the string 2. Check the value of the substring to the value of the Field_2 in a loop using the query below select Field_2 from Table_x where Field_2 like '%45,%' or '%,45%' 3. If return count if >0 then value already exists. Hope this solves the problem. Regards Manoj ----------------------------------------------------------- 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]
