Wilder1626

<div>
Thank you for your help. This is exactly what i needed.
</div>


Thank you for your help. This is exactly what i needed.

<div>
Ho!!! you are correct, sorry, i actually took that one:<br />

<pre><code id="code-20-42705784-1">select substr(description,1,instr(description,'_',-1)) from comment_t</code></pre>
</div>


Ho!!! you are correct, sorry, i actually took that one:


select substr(description,1,instr(description,'_',-1)) from comment_t

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have this query that i would like to modify but i don't know how.<br />
<br />

<pre><code id="code-10-29121826-1">Select Description from Comment_T</code></pre>
<br />
In the Description field, i have value like: TT_MB_1. TT_CC_6, TT_FF_9 etc...<br />
<br />
I would like to get everything from the string up to the last underscore &quot;_&quot;.<br />
Ex: If i have <b>TT_MB_1</b>, it would give me &quot;<b>TT_MB_</b>&quot;.<br />
<br />
How can i do that?<br />
<br />
Thank you for your help
</div>
</div>


Hi,

I have this query that i would like to modify but i don't know how.

(CODE)

In the Description field, i have value like: TT_MB_1. TT_CC_6, TT_FF_9 etc...

I would like to get everything from the string up to the last underscore "_".
Ex: If i have TT_MB_1, it would give me "TT_MB_".

How can i do that?

Thank you for your help

Oracle - Query pull string up to a specific character

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.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.