>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
>
T-SQL doesn't have IIF() function. The CASE function could be used in SQL Server where IIF() would be used in VFP.