Regexp like

From: Joe Smith <>
Date: Thu, 4 Feb 2010 11:23:33 -0600
Message-ID: <BLU108-W204ABCEE0BFA0473ABA92D97550_at_phx.gbl>

Has anybody used REGEXP_LIKE to validate passwords?  

I have a table with strings (i.e. passwords) but this select is not returning any values.  

select * from dept
where REGEXP_LIKE(LOC,'^.*(?=.*{9,})(?=.*\d)(?=.*[A-Za-z])(?=.*[_#]).*$'));  

this should return strings with
at least 9 char
at least 1 digit
at least _ # special char
at least a lower or upper case char  

Does any have any experience with this?  


Hotmail: Powerful Free email with security by Microsoft.
Received on Thu Feb 04 2010 - 11:23:33 CST

Original text of this message