SQL SERVER 2000, basic question 2

[pssheba]

Hi !
i want to operate arithmetic calculations on varchar data types. How do i transform it into numeric ?
Thanks.

 

[johnv20]

all you need to do is cast it as an interger so....

declare @v varchar(20)
set @v = '10'

declare @i int

select @i = (select cast(@v as int))


select i = @i/2

 

[okiiyama]

Here is one way, but you may want to cast the columns as float if you are expecting decimals:

select 'calculated value' = case when isnumeric(columnA) and isnumeric(columnB) then cast(columnA as int)+cast(columnB as int) else 'Not numeric' end
from table1

 

[pssheba]

Thanks a lot guys!
I also found why it didnt work for me. I imported data from a text file and first line was the titles...
Thats why i couldnt implement any cast to numeric. At least i can use your suggestions that broaden my ability to make conversions.