Tearadata Procedure

Database
Enthusiast

Tearadata Procedure

Hi There,

Need your help in stored procedure as am wuite new to this.

I needa stored procedure, in which the column that i pass should always fetch first letter as a character and then it can be anything with numeral or special characters.

Example: If the column value is 123-ab56. The result should be ab56.

               If the cloumn value is ab23hr. the result should be ab23hr

Can somebody help on this please

Regards

Sunny

1 REPLY
Enthusiast

Re: Tearadata Procedure

regexp_substr('123-ab56','([a-z].*)')