Convert Text to decimal.

Question

how to handle below error,

Operand type clash: text is incompatible with decimal

i must data trans for text datatype to decimal data type. in first table all values are decimals.

Answer 1

0

I would suggest you stop using the text datatype and instead use the varchar(max) datatype.

But to cast from text to decimal you'll have to go over a varchar. Like this:

SELECT CAST(CAST(textColumn as varchar(max)) as decimal(10,5))
FROM someTable

answered Apr 17 '12 at 06:02 AM

Magnus Ahlkvist
13.7k ● 13 ● 17 ● 30

(comments are locked)