Why would you do that? IT'S A FLOAT! The question might be valid if you where talking about a DECIMAL or NUMERIC but, by definition, a float is an imprecise number as far as the number of decimal places.

Regardless, INFORMATION_SCHEMA.COLUMNS.NUMERIC_SCALE will tell you exactly how many decimals are being tracked, but that is in conjunction with the Mantissa. You do the math.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Parthasarathy Mandayam
[mailto:mssqldba-ezmlmshield-x17006976.[Email address protected]
Sent: Wednesday, July 28, 2004 9:31 AM
To: LazyDBA Discussion
Subject: RE: REVERSE FUNCTION


You need to declare the number using varchar and then reverse it.


DECLARE @TEST1 varchar(15)

SELECT @TEST1 = 5638123.025

SELECT prec=charindex('.',reverse(@TEST1))-1


Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com







>From: "Jason Volpe "
><mssqldba-ezmlmshield-x71674155.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: REVERSE FUNCTION
>Date: Mon, 26 Jul 2004 12:17:24 -0700
>Received: from www.websitesondatabases.com ([216.55.183.38]) by
>mc4-f41.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Mon, 26 Jul 2004
>12:17:58 -0700
>Received: (qmail 25804 invoked by uid 121); 26 Jul 2004 19:17:02 -0000
>Received: (qmail 28355 invoked from network); 26 Jul 2004 19:17:2 -0000
>X-Message-Info: JGTYoYF78jHqxCLOcGSmIWHjr3YVVbU5
>Mailing-List: contact mssqldba-[Email address protected] run by ezmlm
>Precedence: bulk
>X-No-Archive: yes
>List-Post: <mailto:[Email address protected]
>List-Help: <mailto:mssqldba-[Email address protected]
>List-Unsubscribe: <mailto:mssqldba-[Email address protected]
>List-Subscribe: <mailto:mssqldba-[Email address protected]
>Delivered-To: mailing list [Email address protected]
>Message-ID: <20040726191702.25802.[Email address protected]
>Return-Path: mssqldba-return-7276-MCP111=hotmail.[Email address protected]
>X-OriginalArrivalTime: 26 Jul 2004 19:17:58.0213 (UTC)
>FILETIME=[42B23750:01C47345]
>
>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]
>




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




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page