Sorry about this, but I don't quite get previous postings regarding
select by prioriry.
I have the same question with my sql. I want to be able to select
cell_phone if there is one in the table; otherwise, I will select
work_phone.
table
------
id, name, address, cell_phone, work_phone,...
and I tried using "case when...end" but nope, it's not gonna work. Help
is needed. Thanks.
- Bernie