Viewing 3 posts - 1 through 3 (of 3 total)
INSERT INTO TABLE1(COL1, COL2) SELECT LTRIM(LEFT((COL1 + REPLICATE(' ', 6)), 3)), LTRIM(RIGHT((COL1 + REPLICATE(' ', 6)), 3)) FROM TABLE2
This makes sure that the query will not fail in case of...
April 9, 2002 at 3:45 pm
#426901
Antares686's suggestion works. Thanx.
Prasath.
April 9, 2002 at 3:04 pm
#426896
Hi,
I guess I got answers for some of your questions. But I am not sure how far it will be useful for your work. First of all,...
April 5, 2002 at 1:11 pm
#426733