----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: San4u8 Message 2 in Discussion Hi Deal , declare @strLen int declare @position int declare @str Varchar(200) declare @first varchar(100) declare @second varchar(100) set @second ='' set @first ='' select @strLen= Len(string), @str= lower(string) from firsttable where ID=1 print @strLen print @str set @position = 1 WHILE @position <= @strLen BEGIN if @position%2 = 0 begin set @second [EMAIL PROTECTED] + (SUBSTRING(@str, @position, 1)) end else begin set @first [EMAIL PROTECTED] + (SUBSTRING(@str, @position, 1)) end SET @position = @position + 1 END print @first print @second insert into secondtable(@first,@second) Regards Santosh Ughade Professional Access Software Dev. Pvt. Ltd. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_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]
