Re: TRANSLATE Alfabet to Integer

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 12 Mar 2002 22:43:30 GMT
Message-ID: <mwvj8.21925$Gu6.8936030@typhoon.san.rr.com>

Well, it definitely CAN be done. However, nothing very efficient comes to mind...

create a pl/sql function to do the translation
use nested replace statements ... replace(replace(callind, 'J', '10'), 'K', '11') ...

Note: there won't be any way to convert it back to a string if you use single digits like your example.

Richard Kuhler

R Chin wrote:
>
> Select TRANSLATE(CALLIND,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','123456789..')
>
> I want to TRANSLATE alfhabets into sequential integers....ie. J --> 10 etc,
> can this be done ?
>
> thanks
> Robert Chin
Received on Tue Mar 12 2002 - 16:43:30 CST