On Thursday 24 December 2009 3:47:23 pm Andrus wrote:
> Scott,
>
> >You can use the regex I posted to get rid of the data easily, then go
> >back to the substr one for a check constraint after that.
>
> regex is non-standard.
> How to implement this in standard SQL ?
>
> Andrus.
Why should it matter? The initial data clean up is a one time event. Once the
fields are cleaned up the check constraint will keep them that way.
--
Adrian Klaver
aklaver@comcast.net