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

>
>
>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.
>
>BlockType=1 then return 'Ind' + Block Desc
>BlockType=2 and BlockTypeChar = blank return 'Grp' + BlockDesc
>BlockType=3 and BlockTypeChar = 'S' return 'Spec' + BlockDesc
>
>Thanks

 case when blocktype = 1
           then 'Ind: '+blockDesc 
      when blocktype = 2  AND blockTypeChar = ' '
           then 'Grp: '+blockDesc
      when blocktype = 2
           then 'Spec: '+BlockTypeChar end as mytext
	end as blockdesc,