trim off space

I have a varchar2 column stores data like this '12 3142','1233 412','133 233'. I like to get the first number before the space. ie. '12', '1233', '133'. This means anything after space need to be cut off. I look into the rtrim function but it doesn't do this for me. Can you help?

Thanks,
ewong Received on Thu May 16 2002 - 12:44:00 CDT