hi,
I am trying to save the SQL Query Analyzer results to
a .rpt file.
and i open it in a XL sheet.
every thing is ok, but
when the numbers like ex:
ClientNo
0069007

after saving it to rpt file and if i open in XL sheet ,
the the two zeroes of the ClientNo are being supressed.
i.e. the result in XL sheet is
ClientNo
69007
i want the clientNo as it is (0069007). how to do that.
I used CAST and CONVERT functions in SQL Query analyzer,
but no use.

pls reply me.
thanx,
Hari.

It is more likely to be a formatting issue on the XL side not SQL Server.
Try setting the Cells to be TEXT.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"hari" <anonymous (AT) discussions (DOT) microsoft.com> wrote