Posted by Erland Sommarskog on 12/14/06 10:20

Marko (nortel@planet.nl) writes:
> I put the DECLARE above the Query:
>
> DECLARE @Registernum integer
>
> but no results, I got still the value without the zero (0).
> The Data Type of the Column is CHAR, is this maybe wrong?

Your result set consists of a single integer variable. QA presents integer
values without leading zeroes. How could it now that the integer value
comes from a char column?

If you want to see a leading zero, you should declare the variable as
char or varchar of suitable length.


--
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

• Next in forum: Opinion about design needed (splitting string data)
• Prev in forum: Re: Missing the zero (0)
• Thread view: Re: Missing the zero (0)

[Reply to this message]