----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: shahkalpesh Message 5 in Discussion Hello, As I am understanding your question You need to check whether the value exists in the db The numbers could be inter-changed The no. you could enter is 4 or less than that seperated by , So, why dont you Split the string first based on "," delimiter, you will get an array sort the resulting array & then re-buiild a string from that & then compare this value to the content in your DB (string comparison) Make sure that you insert values in sorted order always e.g your db will always contain row 1 11,22,33,44 instead of 1, 22,33,11,44 I hope this is simple to achieve using SQL Server (I hope so) or even .net In .NET, You will have to use Split method - String class Sort method - Array class Join method - String class Post your reply if this helps you Kalpesh ----------------------------------------------------------- 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]
