help with sql-server query

Question

hi

i have this table:

num | class | Prob

----------------------

1      |     2    |  1 

99    |     4    |  2 

2      |     5    |  3 

99    |     6    |  4 

where Prob = 99 i need * else i need to leave empty

num | class | Prob

----------------------

         |     2    |  1 

*       |     4    |  2 

         |     5    |  3 

*       |     6    |  4 

thank's in advance

Answer 1

select case when num = 99 then '*' else '' end num, class, Prob
from (
select 1 num,2 class, 1 Prob union all
select 99,4,2  union all
select 2,5,3  union all
select 99,6,4 ) t

Answer 2

Try this -

select case when num = 99 then '*' else '' end,
       class, prob from table