IMO, it has to do with the fact that the syntax is erroneous. The other possibility is the fact that the number is stored as VarChar which results in it being retrieved as a string in .NET. Strings do not get formatted using the "#" format specifier.
On Oct 13, 12:26 am, Stephen Russell <[email protected]> wrote: > > 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
