PeopleSoft SQL Query to find alphabets and numbers in Field

posted by Dineshkumar R on January 31, 2013
SELECT * FROM TABLENAME WHERE regexp_like (FIELDTOBECHECKED,'^[A-Za-z0-9]+$')