I have a question about doing a trim for first 3 letters of a phone number, so as to extract the area code for a customer.


Is there any function like ltrim which I could possibly use, passing it the start index and end index along with the column name.

Response would be much appreciated.
Thanx and Regards
Aruneesh

Try:

select substr('888-111-2222',1,3) from dual;

Hi L...DBA
It just skipped my mind about the substr ....

By the way, do u have a document, or any link where the oracle SQL functions are organized in order of functionality.

I know getting a book as an option, but expensive too.
Aruneesh

Hi L...DBA
I had one similar query.
I am creating a list of area codes, and their correspoding zips.

I want to avoid all the invalid zip codes, i mean nothing from Canada should appear. Meaning i just want to use the records which have a 5 digit number as the zip.

Any quickies ?
Thanx and Regards
Aruneesh

Try:

If lenght(zip_code) = 5
And ltrim(translate(zip_code,'0123456789','~'),'~') Is NULL
Then .... 5 digit zip...
Else ... invalid zip ...
End If;