Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 12:56:25 GMT
my solution was the one where I substring to every position. It will work with any number of blanks. It is however contingent on the field being char, not varchar. If it's varchar casting to char is required. I have also tested it. All my inputs were converted correctly. For the one with the case-statements I could even remove non-numerical characters that tend to sneak into phone number fields.
Find my test cases below :)
tel_numb_no_blanks TEL_NUMB 49210325 +49/2103/25 12345678910 12345678910 12345 12 34 5 123456 123 456
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|