<?php SELECT CASE WHEN o.business_type_id = 1 THEN o.first_name WHEN o.business_type_id = 4 THEN o.legal_name ELSE o.business_name END
Select allOpen in new window
<?php SELECT ### Line 1 ### CASE WHEN o.business_type_id = 1[b] THEN o.first_name AND .o.last_name[/b] WHEN o.business_type_id = 4 THEN o.legal_name ELSE o.business_name END