Rich Pinder schrieb:

> Wondering how to handle displaying formatted phone numbers with FB.
> For my Delphi apps, storing as strings of digits only, then using
> 'masks' (or 'pictures formatting', as its sometimes called) is pretty
> easy. And I like the idea of keeping it simple.
>
> But for retrieving via straight SQL from other apps - am I getting into
> trouble? I don't see a UDF to do phone number display formatting
> (couldnt be tough to write I'll guess) - and I guess I could always muck
> up the select statement with an ugly substring/catenation........
>
> what have you all done regarding handling Phone numbers ??

Have a look at the thread "Stripping certain characters from strings"
and I hope you are aware that there are plenty of formats of telephone
numbers out there!

If you ever think about using masks for things like this alsways keep in
mind that maybe there comes the day where you have to store a different
format for a different country!

Luc.

P.S.:
I don't think that using edit masks is keeping things simple.
At the moment I'm struggling with GB-postal codes and I don't think I'd
be any happier using masks or even trying to store them that way in the
database...
;-)