Their SQL equivalents are called LEN and CHARINDEX.
Thanks
Phillip Carter
Ph: +61 3 9235 1691
-----Original Message-----
From: Albert van Biljon
[mailto:mssqldba-ezmlmshield-x61620653.[Email address protected]
Sent: Thursday, 29 July 2004 5:25 PM
To: LazyDBA Discussion
Subject: RE: REVERSE FUNCTION
length and instr aren't valid SQL functions.
--- Chris Hagemaier
<mssqldba-ezmlmshield-x57241040.[Email address protected] wrote:
> Does this work?
> x=length(cast(@test as varchar(25)))-instr(cast(@test as
> varchar(25)),'.')
>
>
>
> -----Original Message-----
> From: Thomas Anthony
> [mailto:mssqldba-ezmlmshield-x71102615.[Email address protected]
> Sent: Wednesday, July 28, 2004 2:50 PM
> To: LazyDBA Discussion
> Subject: RE: REVERSE FUNCTION
>
>
> 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.
>
***********************************************************************
>
>
> ---------------------------------------------------------------------
> 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]
>
>
---------------------------------------------------------------------
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]
IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:
Because this document has been prepared without consideration of any
specific clients investment objectives, financial situation or needs,
a Bell Potter Securities Limited investment adviser should be
consulted before any investment decision is made.
While this document is based on the information from sources which
are considered reliable, Bell Potter Securities Limited, its directors,
employees and consultants do not represent, warrant or guarantee,
expressly or impliedly, that the information contained in this document
is complete or accurate.
Nor does Bell Potter Securities Limited accept any responsibility to
inform you of any matter that subsequently comes to its notice, which
may affect any of the information contained in this document.
This document is a private communication to clients and is not intended
for public circulation or for the use of any third party, without the
prior approval of Bell Potter Securities.
Disclosure of Interest: Bell Potter Securities Limited receives commission
from dealing in securities and its authorised representatives, or introducers
of business, may directly share in this commission. Bell Potter Securities
and its associates may hold shares in the companies recommended.
Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480
MS Sql Server LazyDBA home page