<div>
try this: select replace('THIS IS a test.', ' ', NULL) from dual;
</div>


try this: select replace('THIS IS a test.', ' ', NULL) from dual;

<div>
SELECT REPLACE(&quot;Your String&quot;, CHR(32), '') FROM DUAL will replace any blank spaces in the given string
</div>


SELECT REPLACE("Your String", CHR(32), '') FROM DUAL will replace any blank spaces in the given string

<div>
Why make an additional function call when it is not needed?
</div>


Why make an additional function call when it is not needed?

<div>
You nail it, slightwv. Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
I would like your idea and input on how to trim the blank spaces in between a character string in Oracle. For example I have this character strings as 'I go to sleep' how can I make it to become 'Igotosleep'. I try the trim function but it does not work.
</div>
</div>


Hi All,
I would like your idea and input on how to trim the blank spaces in between a character string in Oracle. For example I have this character strings as 'I go to sleep' how can I make it to become 'Igotosleep'. I try the trim function but it does not work.

How to trim in between blank spaces of a character string in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.