Archives of the TeradataForum
Message Posted: Tue, 30 Jul 2002 @ 13:54:48 GMT
is there any nice way to squeeze the blanks out of a series of characters?
Like, taking my address 2468 MACLAREN CIRCLE and getting 2468MACLARENCIRCLE output
so that the query
select addr_line1 from cust_acct_v where (cust_id, acct_num) in (select cust_id, acct_num from cust_acct_line_v where mtn='6785916417' and mtn_status_ind='A' group by 1,2)
will give 2468MACLARENCIRCLE as an answer?
I tried using CASE Statement, but is there any other efficient way (like stored Procedures) to do this? Any suggestions will be greatly appreciated.
Arun K Ballari,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|