Thanks dude. This is precisely what I want. You the man!
I knew how to do this in VFP as IIF() but not in SQL.
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net
If at first you don't succeed, then skydiving definitely isn't for you.