Working under the premise that "no question is too simple for this list"
Trying to add a constraint so that all phone numbers will be in a
'111-222-3333' format. Tried a few combos, with below the latest effort.
ALTER TABLE "fortour"."mine" ADD CONSTRAINT mine_cnstr_2 CHECK (phone
LIKE '999s999s9999')
and .... LIKE '999-999-9999'
A constraint for length is in place without a problem.
Any help appreciated.
Thanks,
Mike Ellsworth