Thread: How can I conserve the initial zero when convert numeric to string using STR()
View Single Post

   
  #8 (permalink)  
Old 02-29-2008, 07:32 PM
--CELKO--
 
Posts: n/a
Default Re: How can I conserve the initial zero when convert numeric to string using STR()
>> There is at least one obvious case where formatting of output must be done in SQL: to wit when the display is done in a standard query tool like Query Analyzer. <<

No, that formatting is done in the Query Analyzer, which is a program
and not part of SQL. Trust me, we never voted on a "standard query
tool" in ANSI X3H2.

Reply With Quote