Not sure if it matters, but the first SELECT returns 2 columns and the ELSE Select returns 3. They both query the same table.<BR><BR>TheJet >> that's exactly what I was thinking that SQL server ...

It is certainly not easy to learn, as it has a peculiar syntax that is very much of its time. The user experience around SQL can be challenging for new developers to pick up.