<div>
btw: LEFT is a SQL Server function! The equivalent in Oracle would be SUBSTR ;-)<br />
Whatsoever, slightwv's solution is the correct way :-))
</div>


btw: LEFT is a SQL Server function! The equivalent in Oracle would be SUBSTR ;-)
Whatsoever, slightwv's solution is the correct way :-))

<div>
Thanks. This is exactly what i needed.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I would like to know how i can search in an oracle table where the postal code format is 3 digits &amp;&nbsp;&quot; &quot;&nbsp;&amp; 3 gits<br />
<br />
SELECT POSTAL_CODE<br />
FROM LOCATION <br />
where POSTAL_CODE format = &nbsp;LEFT(POSTAL_CODE, 3) + ' &nbsp;' + RIGHT(POSTAL_CODE, 3 );<br />
<br />
How can i do that?
</div>
</div>


Hi

I would like to know how i can search in an oracle table where the postal code format is 3 digits & " " & 3 gits

SELECT POSTAL_CODE
FROM LOCATION 
where POSTAL_CODE format =  LEFT(POSTAL_CODE, 3) + '  ' + RIGHT(POSTAL_CODE, 3 );

How can i do that?

Oracle - Search with postal code have a specific format

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.