All Forums Teradata Applications
mohan.mscss 31 posts Joined 04/11
21 Jul 2012
Teradata Query resolving

I have the following in Column A

28VNC
JR2KL
29C9O
PQS11

I'd like have this result

28
2
299
11

How would I achieve this. Appreciate any help.

CarlosAL 512 posts Joined 04/08
23 Jul 2012

Mohan:

If you want to rip off the letters from the strings, take a look at Oracle UDF oTranslate().

HTH.

Cheers.

Carlos.

You must sign in to leave a comment.