Thanks for the reply and the extra info!

You are right I don't need a trigger.

I was getting inconsistant results with various tests I was doing so I didn't think it...

Thanks for the response. It was definitely helpful.

Thanks for the reply. I am not making several columns the same. Actually what I am doing is when one column has a value the other columns must have a...

Thanks GSquared. I had dug around a little but you know how that goes... it can easily turn into hours!

Check out String Functions in BOL.

You would do something like this:

update table set Username = replace(Username,'$','')

John,

I would say that your answer of NO is probably correct. Although I am no SQL master so maybe there is a way around it...

So far I've gotten this:

Subqueries are not supported in CHECK constraints

Matt,

That's not a bad idea either. I'll have to try that too. Thanks.

Thanks for the reply.

We do control the inserts by SP but at a table level we'll have better control so I added a check constraint to the two child...

I wrote the script tooled around with it. In the script I set the Transaction Isolation Level to Serializable so no data could be modified without the constraints in effect....

Thanks Steve for the replies to both posts. I always looking forward to reading what you have to say.

So I'd have to write:

Drop the constraint objects

Then an Alter (or Drop...

Well my example isn't really an accurate example as to what I'm doing. Below is a trimmed down version of the three tables.

What I have really is a master Lead...

Thanks for the reply.

It's a 1 to 1 relationship so I think that is the way to go. Thanks for the input.

Thanks everyone for the replies.

I did create a PK/FK relationship between the two child tables and the Parent table. This PK/FK ID can only exist in only one of...

Thanks for the reply.

No Data will be deleted from this table. Actually production data is never deleted from the DB.

I guess I'm just used to seeing IDs in...