 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 Jun 2005 @ 15:25:03 GMT
| Subj: | | Re: Comma in string |
| |
| From: | | Victor Sokovin |
| | When I add a -1 as you did, to the substring in order to back out the comma, it throws an error in Teradata. | |
I think you get this error for those addresses which do not contain any commas.
To fix this you might need to introduce something like CASE in your statement but as it was SQL elegance you seem to be primarily after I am
not sure this suggestion would fit.
Regards,
Victor
| |
