• By using the case statement

    select ....,case when money >=10000 then 'A' else 'B' end as Grade

    from ....



    Clear Sky SQL
    My Blog[/url]