How to use case in select statement in SQL Server

 Hi,

   Here i have written a code for Selecting the records from T_CUST_DETAILS Table with CutomerName, Price, CustomerLocation as

Column names, I am using the case for Price Tag as logic written below.

Query

  SELECT

      CutomerName,                                             

           case

              When(Price<50)

                 then

                   'Normal Customer'

              else

                   'Valuable Customer'

           end ,

      CustomerLocation from T_CUST_DETAILS