Re: SOS please help with constraint check with like

juan wrote:

> thank you very much.
>
> i was still looking because i don't know TRANSLATE and i don't know use it.
>
> now my problem finish.
>
> thank you, one more time.

Send payment for doing your work as a donation to the Puget Sound Oracle User's Group. ;-)

Seriously ... TRANSLATE and check constraints are a core skill that you must learn if you are going to work with Oracle. Check out the following pages and perform the examples.

Constraints: http://www.psoug.org/reference/constraints.html Translate: http://www.psoug.org/reference/translate_replace.html

Email me off-line with questions if there is anything on these pages you do not understand.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)