How do I write a CASE statement within my SELECT to do the following:
I have a column called Values
. This column can have the value b
, c
, or a
. If it has the value b
, I want the SELECT to return big
; if c
return small
, and if a
return large