Also is there anyway to update all these character (other than A-Z,spaces,0-9) to spaces.
The below query can use to fetch the values only non alpha (not A-Z) from only one column.
SELECT COL FROM
CASE TRANSLATE(UPPER(COL), ' ','ABCDEFGHIJKLMNOPQRSTUVWXYZ') = ' '
END AS VAL
) AS TEMP
WHERE VAL = 1 ;
I would like to know the query to fetch rows by checking both col1,col2.
Also please provide me the query to update all the invalid character(other than A-Z and 0-9) in all rows to spaces.