select t.colum1,t.colum2

(case

when

t.colum1 = ''

then

''

t.when colum2 = ''

then

''

else

''

end

) as colum3

from table t

04-18 10:21