All Forums UDA
sbarrionuevo 1 post Joined 12/11
03 Jun 2013
I need remove ' ' of rows

Hi, I'm Sebastian and I need your help you. I have rows with '    ' data, for example:
My table have 1 row of the name 'tx_name' and... in the name have:
'     Pepito'(in that case use trim for remove )
'Pepito      Albert'(How remove it this space?)
I try with:
sel oraplace(tx_name, '      '. ' ') from people -- This case have error in tx_name
Can you help me????, Thanks. =)

Harpreet Singh 101 posts Joined 10/11
04 Jun 2013

SUBSTR(name,1, POSITION(' ' IN name))||TRIM(SUBSTR(name,POSITION(' ' IN name)))

You must sign in to leave a comment.