Using A97, I have tables with 10-char text phone number fields to
allow entry of xxxyyyyyyy phone numbers - where xxx is the 3-digit
area code and yyyyyyy is the 7-digit phone number. I wish to display
these as (xxx) yyy-yyyy. Trouble is, some telephone numbers are
entered by users as only 7-digits. They omit the area code in many
cases, understandably. They consider it redundant and its not
necessary for them to dial it - in most cases, only the 7-digit
yyyyyyy part is required.
If I'm displaying them in query, what's the best syntax to put in
the SQL in the field displaying MyTable.MyPhoneNum? If
there's a 10-digit number, I wanna see (xxx) yyy-yyyy and if
there's only 7-digits, I wanna see yyy-yyyy.