Thanks Sergey.. That seems like the ticket. Does the case kind of replace the iif in SQL Server ? I was thinking along the lines of an iif but it didnt like it much in the Query analyzer. Once again thanks you

PAul