case blocktype when 1 then 'Ind: '+blockDesc when 2 case blockTypeChar when ' ' then 'Grp: '+blockDesc else 'Spec: '+BlockTypeChar end as mytext end as blockdesc,Here is the issue. I have a block type that will be 1 or 2, if it's 2, then the BlockTypeChar will either be blank or have a S.