这个sql句子怎么改

select id, tupian, mingcheng, bianhao, case when youhuijia = 0 then 'jiage' else '<font style=\"text-decoration:line-through\">''' & jiage & '''</font>' end as jiage, caizhi, case when youjiajia=0 then ' ' else youhuijia end as youhuijia from shangpin where id in(select shangpinid from shoucang where yonghuid = @id)