----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: BalajiKrishnan Message 4 in Discussion Vinod, I will Transfer the data from a text file to table (tableA). So tableA will have five fields(f1,f2,f3,f4,f5) f5 is the Notes,so now i need to check if the notes(f5) length is greater that 64,000 then i need to break the remining text and insert into the tableb as new record tableA F1 F2 F3 F4 F5 1001 456 55 56 XX.......................XX say if len(f5) is greater than 65,000 then i neen to insert two records like this tableb f1 F2 F3 F4 F5 1001 456 55 55 XX.....XX 1001 456 55 56 XX..XX Second row - column(f50 has remaining text How to do this 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]
