Remove blank spaces

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 17 May 2007 11:06 am

Good morning folks, in a select how do I remove the blank spaces, be it at the beginning, in the middle or at the end.
cleberzumba
Location: Brasília-DF

Cleber Zumba de Souza

Poston Thu, 17 May 2007 11:15 am

Brother, would that be?

Code: Select all

SELECT REPLACE('PAULO TREVISOLLI', ' ', '')
  FROM DUAL;

If you need, have the RTRIM and LTRIM that também may be used.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Thu, 17 May 2007 11:26 am

Cheers cheezburger network, this doubt was beginner ... eheheheh ... but oh well!
Thanks a lot!
cleberzumba
Location: Brasília-DF

Cleber Zumba de Souza

Poston Thu, 17 May 2007 2:28 pm

Vlw brow, needing, we're there!
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to SQL

Who is online

Users browsing this forum: Bing [Bot] and 3 guests