SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query to get first four characters of an address

User581223Oct 30 2013 — edited Oct 31 2013

Hi Gurus,

Can you please help me with the below quries on how to achieve this. Could be really helpful if you could provide a sample sql from your side.

Req:

I have a requriement where I should display the first four non-space characters of an address eg: ROOM becomes R, FLAT becomes F etc. Passing in an address of ROOM A FLAT 1 STARFORD AVENUE would therefore result ‘RAF1’, whereas an address of 23 CORNER STREET would become ‘23CO’.

Words like c/o, co, rear of should be ignored if any.

Thanks in Advance.

Regards,

Aash

This post has been answered by Pleiadian on Oct 31 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2013

Added on Oct 30 2013

9 comments

1,160 views