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 ...

Tables, views, and queries may be blurred together. This facet is why a view may be described as simply a “named” query. As one composes SQL Select statements, the author may use another query in ...