get the integer value , using SQL statement

[discusmania]

Hi...

Let say I have an oracle database table name employee with badge column. sample data for this column are:
badge
-----
00004567
00002345
00012345
00012319
00234567

and i have a string , lets say '4567'. so i just want out information for employee 4567. I try to use this command :
SELECT * from employee where to_number(badge)='4567'

but looks like the statement is wrong. Have anyone any idea on this ?

Thanks and regards
Ron

 

[Targol]

toNumber

function returns a numeric. so when doing this :

SELECT * from employee where to_number(badge)='4567'

you try to compare a numeric and a string. Try :

SELECT * from employee where to_number(badge)=4567

Water is not bad as soon as it stays out human body ;-)