Re: How to enforce a string format in a field??

From: HansF <news.hans_at_telus.net>
Date: Sun, 28 Nov 2004 00:14:36 GMT
Message-ID: <ML8qd.10132$VL6.3268@clgrps13>

"Michel Cadot" <micadot{at}altern{dot}org> wrote:

> 
> "Ramon F Herrera" <ramon_at_conexus.net> a écrit dans le message de
> news:c9bc36ff.0411270245.4145eb43_at_posting.google.com...

>> My database contains a field called 'SSN' whose
>> contents should be obvious.
>>
>> Is there any way to constrain that field to the
>> following format: ddd-dd-dddd? That is: if there is
>> an attempt to insert a value that doesn't have 9 digits
>> with the hyphens in the proper places, the record should
>> be rejected.
>>
>> Or is this something that I should check before inserting
>> the data into the table (for instance, making sure that
>> the *.dat file only contains proper SSN values)??
>>
>> TIA,
>>
>> -Ramon F Herrera

> 
> alter table mytable add constraint myct
> check (regexp_like(myfield,'^[:digit:]{3}-[:digit:]{2}-[:digit:]{4}$'));
> 

Good one Michael. But isn't there a version restriction that we should tell the OP? (Regardless that the OP didn't tell us what version is relevant.)

/Hans Received on Sat Nov 27 2004 - 18:14:36 CST