trim off space

From: Ed Wong <ewong_at_mail.com>
Date: 16 May 2002 10:44:00 -0700
Message-ID: <a5ae1554.0205160944.75ff0942@posting.google.com>

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