Subject Re: [firebird-support] Best way to store Phone Numbers ??
Author Woody (TMW)
From: "Alan McDonald" <alan@...>
>
> this is really something for your client layer to handle.
> Have you thought what will happen with this function if your users are
> permitted (i.e. no mask provided for them) to enter
> 123-4567890
> or
> (123)4567890
> or
> 123 4567890
> ??
> or what happens if they enter (818) 522-3329?
> Plus it's no fun for a user to have to enter
> 1234567890
> and work out if they've entered a mistaken digit.
> The result will be mess.

Alan, the function that I just posted ignores any additional characters
already in the phone number by stripping them out first before applying the
format. I think it should do what he needs, but I'll wait to find out.

Woody (TMW)