Archives of the TeradataForum
Message Posted: Sat, 03 Apr 2004 @ 19:17:55 GMT
I was wondering if anyone knows of a solution on how to remove the apostrophe from a char type column value. I know we can use the substring and position functions but I am having a hard time on making the system find the apostrophe using the position function.
sel position ( ' ' ' in a.location_name) as "tcolumn" from table_name a where position ( ' ' ' in a.location_name) > 0;
Any help is always greatly appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|