cast function problems

Hi,
In one of my tables, one of the columns (Salary) is of type
varchar(255). I want to conver it into int(11). When I do a test to
see if get the result, I have the following problems.

select cast(Salary as unsigned int) from mydb;

Truncated incorrect INTEGER value: '150000.00'


ie, if the Salary has a decimal point, it gives me an error. Any
suggestions?

Thanks.

Actually, I am trying to insert this salary value ( from varchar(255))
into a table which has a type int(11). Thats when I get this trouble.
insert into mydb2 (select cast(Salary as unsigned int) from mydb)

Truncated incorrect INTEGER value: '150000.00'

mydb2 has Salary int(11);

Thanks.

On Apr 17, 5:39 pm, PGPS <premg...@gmail.com> wrote:
> Hi,
> In one of my tables, one of the columns (Salary) is of type
> varchar(255). I want to conver it into int(11). When I do a test to
> see if get the result, I have the following problems.
>
> select cast(Salary as unsigned int) from mydb;
>
> Truncated incorrect INTEGER value: '150000.00'
>
> ie, if the Salary has a decimal point, it gives me an error. Any
> suggestions?
>
> Thanks.

Found the solution myself, the problem was solved if I convert the
varchar to decimal and then to integer

cast(cast(SalaryMin as decimal(8,0)) as unsigned integer