Searching Teradata via regular expressions.

[CapsuleCorpJX]

Hey guys, I know I can do a string search in teradata using the % wild card. But does Teradata handle regular expression searchs? Like say give me all the rows in a table that have a phone number in it matching format (###-####)

 

[al1024]

You have two wildcards : % and _
_ replaces a single char.
So you can test your format with : expr like '___-____'

 

[CapsuleCorpJX]

Hmm, but that doesn't specify integers only at those positions.
So ABC-DEFG will also work.