Showing posts with label sal. Show all posts
Showing posts with label sal. Show all posts

Friday, February 24, 2012

how i convert varchar sal field to numeric in query

how i convert varchar sal field to numeric in query

select sum(sal) from emp1

error:the sum or average aggregate operation cannot take a varchar data type as an argument.

Use Cast as in:

select sum(cast(sal as float)) from emp1