jeudi 6 avril 2017

Oracle SQL Alphabetic Patern Recognition

How do I use LIKE or REGEXP_LIKE to only find records where the first 5 characters are alphabetic (A-Za-z) only? I've tried several different attempts without success, including trying to include a 5 character substring.

SELECT * FROM table WHERE sourcecode LIKE ????

Aucun commentaire:

Enregistrer un commentaire