Tuesday, August 11, 2009

Query to Find Unwanted Characters

select addr_line_1 from table_name
where translate(upper((trim(addr_line_1))),
CHR(0)||' QWERTYUIOPASDFGHJKLZXCVBNM ,.<>/?;:''"[{]}1234567890-=!@#$%^&*()_+\|`~ \n'),
CHR(0)
) IS NOT NULL

No comments: