Posted by Erland Sommarskog on 12/13/06 22:58

Marko (nortel@planet.nl) writes:
> I hope someone can help me; if got a value in a cell (040 1234567),
> when I run a query
> in the Analyser I got as respons only 40 1234567, so missing the zero
> (0) not the whole number is displayed. When I run a query on a cell
> with value 1234567 I received the number 1234567 and that's oke. The
> Data Type of the Column is Char.

Cell? Do you mean column value in a row? Or are you running a query
against Excel?

What exact query do you run?

All I can say is that the leading zero should normally not be dropped
for a character value, which this obviously is, there is a space in it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]