CASE in SELECT for aliases?

[imstillatwork]

a table has clinic_name, name_f, and name_l

If the clinic_name is blank, I want to use 'name_f name_l' instead. I want to sort by this also, so can I write a CASE statement that will check if the clinic_name is null or blank and assign the alias accordingly?

Like this? (doesn't work, and I left out the concat() for the name_f & name_l)

CASE
WHEN clinic_name1 = '' THEN name_l AS title
ELSE clinic_name1 AS title
END

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[r937]

CASE WHEN COALESCE(clinic_name1,'') = '' 
     THEN CONCAT(name_l,', ',name_f)
     ELSE clinic_name1 
END AS title

r937.com | rudy.ca