convert varchar to int in sql

snowal raj

9y1.1kSQL

Hai,

i have 2 columns in table are

column name datatype is varchar

column Amount is nvarchar

i want sum the amount against name.plz help me

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
Select name, sum ( convert (int, Amount)) as Total from tablename Where name not in ('Rangaraj C') groupby name
+1
Subhashkumar Yadav9y ago
Use the Below Select Query:-

SELECT NAME, SUM ( CONVERT (INT, AMOUNT)) AS TOTAL FROM TABLENAME WHERE NAME NOT IN ('RANGARAJ C') GROUP BY NAME
-1
snowal raj9y ago
I want to sum all the fields and skip the name of Rangaraj C.
0
snowal raj9y ago
can u plz give a code format
0
Amit Gupta9y ago
Clarify your question, 1.You want to sum the amount and don't sum the Rangaraj c field Or 2. You want to sum all the fields and skip the name of Rangaraj C.
0
Amit Gupta9y ago
You can add where clause Select name, sum ( convert (int, Amount)) as Total from tablename Where name not in ('Rangaraj C') groupby name
+1
snowal raj9y ago
thanks amit,

i want sum e amount without Rangaraj C ,
Rangaraj c's amount is visible.below the result i want

Name Amount

Karthikeyan R 62

Mohammedhussain T M 19

Mythili V 37

Rangaraj C 145- $4358.14
0
Amit Gupta9y ago
Hey snowal,
I suggest you to put the datatype of amount column to int or decimal, it will help you to get benefit in future.

Coming to your query, try this

Select name, sum ( convert (int, Amount)) as Total from tablename groupby name
+1