MS SQL Server, Copying data from a TEXT field into two Varchar fields

Copying data from a TEXT field into two Varchar fields

Author	Message
TG #1 / 3	Copying data from a TEXT field into two Varchar fields Hi, I'm having difficulty in finding out how to copy data from a TEXT field, which would contain no more than 400 chars, into two Varchar fields of 200. If anyone has any ideas on how to do this, I would greatly appreciate any help. Thanks Terence
Fri, 16 Mar 2001 03:00:00 GMT

huh #2 / 3	Copying data from a TEXT field into two Varchar fields X-no-spam: yes X-no-archive: yes TG, Copy your blob to another blob (e.g. in temporary table) Then you can copy first n characters (n<=255) to varchar variable - simply converting the text to varchar. To get characters after 255th character, shift your blob left - see updatetext for more information and then again convert to varchar and copy. Hope this helps. Quote: >Hi, >I'm having difficulty in finding out how to copy data from a TEXT field, >which would contain no more than 400 chars, into two Varchar fields of 200. >If anyone has any ideas on how to do this, I would greatly appreciate any >help. >Thanks >Terence
Fri, 16 Mar 2001 03:00:00 GMT

Christer Romso #3 / 3	Copying data from a TEXT field into two Varchar fields convert(varchar(255), text_col) will retrieve the first 255 characters. Then delete these (with updatetext) and get the next 255 the same way. (You'll probably want to copy the text data to a temp table before yuo do this). Christer Romson Terence: Quote: >I'm having difficulty in finding out how to copy data from a TEXT field, >which would contain no more than 400 chars, into two Varchar fields of 200. >If anyone has any ideas on how to do this, I would greatly appreciate any >help.
Fri, 16 Mar 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]