title: How to switch sql-2005 Select Case When T-sql Naming?
body: <pre><code>select 
  (Case Remark01
  When 'l1' then type1
  when 'l2' then type2
  end) AS [?] --Remark .....want to switch name in here
  from mytable
  </code></pre>
  
  <p>Example ....</p>
  
  <pre><code>select 
  (Case level
  When 'l1' then type1 ('l1' mean check constant string)
  when 'l2' then type2(('l2' mean check constant string))
  end) AS <b>(Case when 'l1' then [type01] Else [type02])</b>
  from mytable
  </pre>
  
  <pre>select level,type1,type2 from mytable
  </code></pre>
  
  <p>I using two program this mytable<br>
  one program is want to show menu only type1 only<br>
  one program is want to show menu only  type2 only<br>
  I using one view using two program..</p>