Sunday, October 24, 2010

SQL number with .00 decimal 2 disgits

SQL number with .00 decimal 2 disgits

Query
SELECT CONVERT(VARCHAR,CONVERT(VARCHAR,786),0) as Currency_COL

Result
------------------
Currency_COL
------------------
780.00
------------------
Posted by at
Labels:

2 comments:

  1. AnonymousJanuary 12, 2011 at 3:47 AM

    torebki skórzane
    to torebki zamszowe , torebki david jones , torebki online . torby skórzane , kazar ?

    ReplyDelete
  2. AnonymousJanuary 14, 2011 at 3:15 AM

    INSERT

    ReplyDelete

Subscribe to: Post Comments (Atom)