Hi

Declare the data type as decimal

The following one is work

DECLARE @TEST1 decimal(11,3)

SELECT @TEST1 = 5638123.025

SELECT @TEST1

SELECT REVERSE (@TEST1)

rgds,
Sugnathan,V

> -----Original Message-----
> From: Jason Volpe
> [SMTP:mssqldba-ezmlmshield-x71674155.[Email address protected]
> Sent: Tuesday, July 27, 2004 1:17 AM
> To: LazyDBA Discussion
> Subject: REVERSE FUNCTION
>
> I am trying to get the len of the decimal places in a float(25) number,
> and
>
> getting funky results. Thinking the number is too large for float but
> doesn't
>
> make total sense. Any ideas? Was reversing it so I have the decimals
> in
>
> the front, and then using len on that, but think its not possible to do
> what im
>
> trying to do.
>
>
>
> DECLARE @TEST1 FLOAT(25)
>
> SELECT @TEST1 = 5638123.025
>
> SELECT @TEST1
>
> SELECT REVERSE (@TEST1)
>
>
>
> Jason Volpe
> Information Systems Management
> intesource Powering Procurement, Advancing Business
> office: 602-445-2291
> mobile: 480-452-7269
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page