Re: SQL TO_DATE

Works nicely, thanks!

"Venkat" <veeve_2000_at_yahoo.com> wrote in message news:0Rz2b.21$V06.273_at_news.oracle.com...
>
> Do a TRANSLATE on the second SUBSTR().
>
> Example from the doc:
>
> SELECT TRANSLATE('2KRW229',
> '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789')
> "Translate example"
> FROM DUAL;
>
> Translate example
> -----------------
> 2229
>
>
> Cheers,
> -V
>
Received on Mon Aug 25 2003 - 21:56:19 CDT