Rename variable in select statement?

gsmdude · #1 (**permalink**) 04-20-10, 05:43

I'm trying to temporarily rename a variable in my select statement for sorting. For instance, "Research in Motion" is the company name, but I'd like to replace it as "BlackBerry" to sort so the output is, say:

Apple
BlackBerry
Motorola
Samsung

Is there a command that can let me do this without replacing the actual value? Thanks.

r937 · #2 (**permalink**) 04-20-10, 06:48

use a CASE expression

Code:

SELECT CASE WHEN company = 'Research in Motion'
            THEN 'Blackberry'
            ELSE company END AS temp_company
  FROM ...
ORDER
    BY temp_company

Internet Services

Web Development

Digital Marketing

Consumer Tech