[SQL] How to convert string to integer

[venkat]

Dear All,

  How do i convert string to int

select SUM(pan_1) from customers1 where name='101'

When i run the above query i m getting  "function sum(character varying)
does not exist"..

Please anyone can guide me..

Thanks