Archives of the TeradataForum
Message Posted: Wed, 14 Jul 2004 @ 10:34:18 GMT
| Subj: | | Re: Cleaning Database Columns |
| |
| From: | | Victor Sokovin |
Anomy Anom wrote:
| | A similar question was posed few days back and the reply was to run the following query to set non-numeric values to null - | |
| | UPDATE table_x SET x = NULL WHERE UPPER(x) CST = LOWER(x); | |
I'm afraid that wouldn't be my executive summary of the thread, which started here:
www.teradataforum.com/teradata/20040616_154334.htm .
To list just a few exceptions:
sel '123 ; =C3=9F =C5=A1 =C2=A9 =C2=B5' X, 'we ignore this filter!'
WHERE UPPER(X) (cs) = LOWER(X) ;
Regards,
Victor
| 
