how to cast the particular column to decimal

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

SQL

SELECT 'IATA' AS 'MODULE',(SELECT * from [DBO].[FormatIndianCurrency](cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT'  FROM TABLE NAME

I'm not able to cast this amount column to decimal.when i execute it is showing an error--

Incorrect syntax near 'cast', expected 'AS'.

can u please suggest me any solution

Posted 25-Jun-12 1:07am

premkumar.r

Add a Solution

Comments

Ganesan Senthilvel 25-Jun-12 7:08am

It is not a good practice to write the description in CAPITAL letters.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2012-06-25T01:09:00

Solution 1

SQL

SELECT 'IATA' AS 'MODULE',(SELECT (cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT' from [DBO].[FormatIndianCurrency])  FROM TABLE NAME

You should write that operations in SELECT statement.

Posted 25-Jun-12 1:09am

Hiren solanki

Updated 25-Jun-12 1:14am

v2

Ganesan Senthilvel · Answer 2 · 2012-06-25T01:14:00

Solution 2

Looks like there is a mismatch in the parenthesis at line 3. You need to fix 3rd line to resolve the bug.

SQL

SELECT 
'IATA' AS 'MODULE',
(SELECT * from [DBO].[FormatIndianCurrency]
(cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT'  
FROM TABLE NAME

Posted 25-Jun-12 1:14am

Ganesan Senthilvel

sanwar_mal_jat · Answer 3 · 2012-06-25T01:46:00

Solution 3

Hello mismatch parenthesis in cast so use it,

SQL

SELECT 'IATA' AS 'MODULE',(SELECT * from [DBO].[FormatIndianCurrency](cast(ISNULL(SUM(AMOUNT)*-1,00) as decimal(19,2)))) AS 'AMOUNT'  FROM TABLE NAME

Posted 25-Jun-12 1:46am

sanwar_mal_jat

how to cast the particular column to decimal

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

how to cast the particular column to decimal

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us