HI I need to get text into limited string lenths between two sql tables, one
outputs a 60 string lenth and the input will only take 45 characters.so I
need to split at character 46 but then merge the next line to the 15 that was
split from the cell before !
example :
cell 1 100 FOOT OF 3.1/4" TAB R CHAIN @ 4.00PDS / FO
cell2 OT
cell 3 80 FOOT OF 3.1/4" TAB CHAIN @ 3.50PDS / FOOT

So cell one have been truncated at character 45 and character 46 and 47 have
been split onto cell 2 but now I need to merge cell 3 into cell 2 and then
truncate that at character 45.
Any help would be apreciated

regards

Kev