Pages

Monday, October 22, 2012

Query to search Special character in word


The query looks for any special characters in column field (specially useful for password field) and reports it.  

SELECT DISTINCT employee,PASSWORD 
FROM
(SELECT employee,LENGTH(TRIM(TRANSLATE(password, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' '))) KEY,PASSWORD 
FROM table_name) 
WHERE KEY IS NOT NULL


No comments:

Post a Comment