Can you sum varchar

The best thing, of course, would be to change the table definition so that the column is int. That's not always an option, but if it is for you, that's what I advise.

Hi jhon can you explain me how do it?? In thi table have all values that it's "numeric" like this i0m sorry but i'm really newbie with sql. OK, so you've got numbers with decimal components, but you want to convert them to int? What is the rule - disregard everything after the decimal point, round to the nearest whole number, round to the next lowest whole number, round to the next highest whole number, or something else?

Perhaps you could show us what you've already tried? Hi john haven't only tried to see wich values have in this table, need only to check and SUM all Values until first number after decimal point. If in the future, you should say a prayer, say one for them.

And if in the future, you should light a candle, light one for them. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid.

Related Questions. How to sum two varchar value. Sum if is value varchar. How do sum varchar column. Increment a varchar value. How can we pass varchar input to a SQL function? How I sum or aggregate time data in SQL server. Layout: fixed fluid. Web01 2. Strip HTML. Encode HTML. Paste as-is. Code block. Quoted Text. Did you see my first reply?

Can you not just do Understanding the problem, now, that's the hard part. As always, you post simple methods Madhivanan Failing to plan is Planning to fail wanni Starting Member 14 Posts Posted - : quote: Originally posted by madhivanan Well.

Madhivanan Failing to plan is Planning to fail yes , thanks!! Ryan Randall www. Subscribe to SQLTeam.