Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 10:53:36 GMT
I need to be able to get rid of 'spaces' in a telephone number field using Teradata SQL is there a function to allow this? The spaces could be in any position within the 11 character field? I've found the 'trim' function but this only removes trailing and leading blanks?
example before: 01234 56789 after 0123456789.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|