I need remove ' ' of rows

UDA

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. =)

1 REPLY
Enthusiast

Re: I need remove ' ' of rows

SELECT

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