Home » Server Options » Text & interMedia » Multiple options in Check Constraint
Multiple options in Check Constraint [message #76105] Thu, 22 July 2004 22:02 Go to next message
ID
Messages: 17
Registered: February 2004
Junior Member
Hi friends,

 I m trying to put a check constraint on a particular column say Emp_Name of Emp table and I want it(Emp_Name) should start with either 'P' or 'S'. How will I able to put this condition thru a Check Constraint on this column.

    Thnx in adv.

         ID

    

Report message to a moderator

Re: Multiple options in Check Constraint [message #76146 is a reply to message #76105] Sun, 28 November 2004 09:07 Go to previous message
Just John
Messages: 69
Registered: November 2004
Member
this code provides the (an) answer.

SELECT *
FROM emp
WHERE SUBSTR(Emp_Name,1,1) IN ('S','P');

Report message to a moderator

Previous Topic: How to use & in contains keyword in context index
Next Topic: Oracle Context - Solution
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 27 19:37:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.