Subject | Best way to store Phone Numbers ?? |
---|---|
Author | Rich Pinder |
Post date | 2005-03-07T21:25:01Z |
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 ??
thanks
Rich Pinder
USC School of Medicine
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 ??
thanks
Rich Pinder
USC School of Medicine