convert varchar to int in sql

Question

Hai i have 2 columns in table are column name datatype is varchar column Amount is nvarchar Name Amount Karthikeyan R 11 Karthikeyan R 51 Mohammedhussain T M 19 Mythili V 37 Rangaraj C 145- $4358.14 i want sum the amount against name.plz help me

Amit Gupta · Answer

Select name sum ( convert (int Amount)) as Total from tablename Where name not in ('Rangaraj C') groupby name

Amit Gupta · Answer

You can add where clause Select name sum ( convert (int Amount)) as Total from tablename Where name not in ('Rangaraj C') groupby name

Amit Gupta · Answer

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

Subhashkumar Yadav · Answer

Use the Below Select Query:- SELECT NAME SUM ( CONVERT (INT AMOUNT)) AS TOTAL FROM TABLENAME WHERE NAME NOT IN ('RANGARAJ C') GROUP BY NAME

snowal raj · Answer

I want to sum all the fields and skip the name of Rangaraj C.

snowal raj · Answer

can u plz give a code format

Amit Gupta · Answer

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.

snowal raj · Answer

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

Name	Amount
Karthikeyan R	11
Karthikeyan R	51
Mohammedhussain T M	19
Mythili V	37
Rangaraj C	145- $4358.14