OK I get it. Should really read BOL before posting!

I also don't get it. Why doesn't it cast 34 to char(34) (double quotes ?)

Anyone care to enlighten us?

Hey! Not fair. I lost a point because of a missing ORDER BY ? Like a previous poster mentioned, both 1 and 2 are correct. :crying:

Can I get my point...

In the code that generates the DROP CONSTRAINTS for the foreign keys, I can't get this to work unless I change rkeyid in the WHERE clause into fkeyid, which kinda...

Thanks Matt. Works a treat.

Why is it always the simpliest things that cause grief?

Cheers

-- Mike