|
|
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
Navigation:
[Reply to this message]
|