Converting Decimal to String W/O Decimal Point

[JD]

I'd like to convert a Decimal value into a string so that the entire
original value and length remains intact but there is no decimal point.

For example, the decimal value 6.250 is selected as 06250.

Can this be done?

[JW]

Re: Converting Decimal to String W/O Decimal Point

select replace(cast (6.250 as varchar),'.','' )

JD wrote:[color=blue]
> I'd like to convert a Decimal value into a string so that the entire
> original value and length remains intact but there is no decimal[/color]
point.[color=blue]
>
> For example, the decimal value 6.250 is selected as 06250.
>
> Can this be done?[/color]

[JW]

Re: Converting Decimal to String W/O Decimal Point

select replace(cast (6.250 as varchar),'.','' )

[JW]

Re: Converting Decimal to String W/O Decimal Point

but length doesn't remain intact

[JW]

Re: Converting Decimal to String W/O Decimal Point

but length doesn't remain intact

[JW]

Re: Converting Decimal to String W/O Decimal Point

select replace(space(1 )+replace(cast (6.250 as varchar),'.','' ),' ','0')

[JD]

Re: Converting Decimal to String W/O Decimal Point

Thanks!!!