On Tue, Oct 12, 2010 at 1:16 PM, BD <[email protected]> wrote: > I am storing phone numbers on the back end sql server database in an > unformatted nvarch type of column. I want to display the stored data > as US phone number (XXX) XXX-XXXX. I tried to do this in the asp tag > for a label and have been unable to make it work. When it did work, > it threw me an error such as: > > FormatException was unhandled in user code. Input string was not > in a correct format. > > I think it has to do with the column allows nulls. ---------------------------
No it has to do with data collection and nothing to do with storage. You can fix it on the extraction easily with ISNULL(phoneNumber, 'YourStringHere' ) -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell
