Re: how to trim the last 2 digits??

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 05:52:09 -0500

Answered in .clients 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"ricky" <anonymous@discussions.microsoft.com> wrote in message
news:D33E6DE0-A4B7-44CD-BAF9-C4E848AFB27F@microsoft.com...
> amount
> before:
> 82.7586
> 960.0000
> 331.0345
>
> After:
> 82.75
> 960.00
> 331.03
>
>
> hi there,
>    i want to trim last 2 digit. how can i accomplish in sql script???
>

Relevant Pages

  • Re: Non Paged Memory Error
    ... amount of client connections. ... I have the necessary amount of CAL's for my ... Outlook 2003 clients are not in cached mode, ...
    (microsoft.public.exchange.admin)
  • Re: Internet traffic and Azureus -
    ... becomes a break-even or no-profit, add users like you and its a clear ... loss, you will find one of two things happening, prices skyrocket or ... It is typical for ISPs not to install the amount of infrastructure ... really required for their clients. ...
    (Fedora)
  • Re: Non Paged Memory Error
    ... amount of client connections. ... I have the necessary amount of CAL's for my ... Outlook 2003 clients are not in cached mode, ...
    (microsoft.public.exchange.admin)
  • Re: FC1 - Evolution Pauses While Building Vfolders
    ... Due to the large amount of email received/sent each day to clients, ... > I use an elaborate email layout containing a separate folder ... > required folders for email sorting usage. ...
    (alt.os.linux.redhat)
  • Re: FC1 - Evolution Pauses While Building Vfolders
    ... Due to the large amount of email received/sent each day to clients, ... > I use an elaborate email layout containing a separate folder ... > required folders for email sorting usage. ...
    (alt.os.linux.redhat)