Hi guys.

I need validate a field string in a table. It needs have a specific mask

I want use regex + CASE expression

There is any function to this purpose in SQL?

Hi guys.

Do You known If Caché has suport to Common Table Expressions (With queries)

By example: https://www.postgresql.org/docs/9.6/static/queries-with.html