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


2 comments:

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

    ReplyDelete