T-SQL cannot convert varcchar column to a numeric datatype

Question

i have the following T-SQL statement:

select top 10 value1 from table1 where condition1 = 12345

result:

the data type of value1 = "[char] (20) COLLATE Latin1_General_CS_AS NULL"

please note, each result line has 20 chars i.e. "5449.0______________" filled up with spaces.

I want to sum all this columns. how can i convert these values to a summable data type?

possible duplicate of Convert a string to int using sql query — Evan Trimboli
– Evan Trimboli, Commented Mar 3, 2015 at 9:51

Las Ten · Accepted Answer · 2015-03-03 10:04:09Z

0

Use cast or convert:

-- for demo
declare  @v char(20)
set @v = '228231.9            '
-- real magic
select cast(@v as real)

So this is the select in your case:

select cast(value1 as real) from table1 where condition1 = 12345
select sum(cast(value1 as real)) from table1 where condition1 = 12345

answered Mar 3, 2015 at 10:04

Las Ten

1,17510 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

T-SQL cannot convert varcchar column to a numeric datatype

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related