-
trim off the write space
Hi all,
I have a question on the trimming off the extra white space.
SET LINESIZE 300
f1 f2 f3
aaaaa,bbbb,ccccc
ddddd,eeee,fffff
SELECT f1||chr(13),f2||chr(13),f3
FROM
aaaaa,
bbbbb,
ccccc < THERE are SOME big white space here >
ddddd,
eeeee,
fffff < There are Some big white space here >
What is the best way to remove off the big white space ?
Thank You
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|