Displaying Leading & Trailing zeros

[mssql]

I have a situation where I need to display leading & trailing zero's from a numeric field. For instance if user enters 0950, when I select the data back from sybase it gives me 9.5 . How do I get it to display the total value 0950?

Would appreciate any help.

 

[Tim1]

Hiya,

The easiest way to do this is to use the convert function. You can then make your number into a string and format the output as you wish.

Tim

 

[Lutfal]

In little details:

just change your select query using the convert funtion (convert the numeric field into int ):

Eg

select product_id from products

.....becomes

select product_id convert (int, products.product_id) from products

The output result
for product_id will show the trailing zero. You can convert into varchar for showing both zeros

' where product_id asumed to be an numeric field