Character to integer conversion function

I am a former Oracle person who can't seem to find an INT() function that takes a string and give an integer value that you can use within an SQL command. (Like an atoi() in C). I'm sure there must be one. Any help appreciated