----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 3 in Discussion The logic that I gave assumed 4 pairs always, but if you 1, 2, 3, or 4 pairs, try chaning the @found condition in the program. IF (@found = 4) must be changed to IF (@found IN (1, 2, 3, 4)) I think this will work for your case. Although the logic may work fine, remember that SQL Server is not suited for this kind of logic. For example, splitting the string based on the delimiter is one line of code in VB.NET, but it is several lines in SQL. I would suggest that you relook at writing this logic in your application tier. Before inserting data, you can read the input fields and then perform this check in the application tier. This should make the code more manageable. Think about it.... 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]
