CASE WHEN blocktype = 1 THEN 'Ind: '+blockDesc WHEN blocktype = 2 AND LEN(BlockTypeChar) = 0 THEN 'Grp' + BlockDesc ELSE 'Spec: '+BlockTypeChar end as blockdesc,>Anybody know how I can do this?
> case blocktype > when 1 then 'Ind: '+blockDesc > when 2 > case blockTypeChar when ' ' then 'Grp: '+blockDesc else 'Spec: '+BlockTypeChar end as mytext > end as blockdesc, >>