I like to store the format with the string. Makes it easier on other folks using the data. I.E. A user creating reports. It just makes more sense to me to store the data the way you are going to want to view it.
Pf
>Hi Folks.
>
>The "R" Format property. You know, the thing that applies a format mask to data as specified in the InputMask property. The Builders love it. I don't. Phone numbers, for example. If the data is stored as (999) 999-9999 and you use (999) 999-9999 as your InputMask and have R in the Format, you end up with a display that looks like "((99) 9) 99", or something to that effect.
>
>Frankly, I like to store data as formatted so that I don't have to worry about formatting it from whatever front-end I get it from. So the "R" is worse than useless for me.
>
>What do y'all think?
(On an infant's shirt): Already smarter than Bush