how to trim the last 2 digits??

From: ricky (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 02:31:12 -0800

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

  • how to trim last 2 digits???
    ... i want to trim last 2 digit. ... how can i accomplish in sql script??? ...
    (microsoft.public.sqlserver.clients)
  • Re: Vista hosting XPe tools/db
    ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
    (microsoft.public.windowsxp.embedded)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Vista hosting XPe tools/db
    ... here's an alternative script using the Microsoft ADO as ... opposed to the SQL DMO - this should allow this script to work ... Microsoft Windows XP Embedded Test Team ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windowsxp.embedded)