0 - 1 of 1 tags for SPECIAL CHARACTER
Remove of Period '.' from my concatnated string.

I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.
 
My query is
SEL CONCAT(id, rec_num, line_no, dep_no, asp_num, pr_num) as mystr
from table_oemsp
 
I get the output as
mystr
0.0.300.900.0
11.20.123.123.20
etc.
 

By ikonofamerica, 29 Jul 2013 | Tagged: concat format period string SPECIAL CHARACTER | 2 comments