----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Arian_Intellect Message 2 in Discussion Hi Balaji, What u can do is ... when u pass a value to the back a new or existing.. select the old values in the form of a string into a table by split with the "," de-limiter. run a cursor and validate against the new value whether exists or not else u can use the charindex Shaju Thomas e-Cosmos Technologies Ltd., Mail: [EMAIL PROTECTED] Phone(Off) : 51217037/38 Extn: 132 Mobile: +91 98455 21794 ----- Original Message ----- From: BalajiKrishnan To: BDOTNET Sent: Monday, November 24, 2003 1:07 PM Subject: SQL QUERY - HELP ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: BalajiKrishnan Message 1 in Discussion Dear All, I have a requirement....... I am storing a field value as 32,43,56,57 only 11 characters are allowed to stored. Now when inserting a new record i want to check this combination already exist in the table. for example when i try to insert 32,56,43,57 it should say value alreay exist. when i try to insert 32,56,57,45 then it should insert a new record.. how can i do this..... If i am not clear i will tell you more pls help this is very urgent Thanks in advance Balaji ----------------------------------------------------------- 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] ----------------------------------------------------------- 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]
