Archives of the TeradataForum
Message Posted: Wed, 13 Jul 2005 @ 14:07:34 GMT
Can anybody please tell me how to remove blank spaces from data field?
e.g. NAME="FIRSTNAME LASTNAME"
NAME is field in table and "FIRSTNAME LASTNAME" is data. I need to get data as below
NOTE: We some fields with more blanks spaces as well e.g. ABC Cons Services Ltd.
I need to remove or replace all these blank spaces.
Thanks in advance for your help.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|