Teradata Query resolving

Teradata Applications
Enthusiast

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.

1 REPLY
Junior Supporter

Re: Teradata Query resolving

Mohan:

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

HTH.

Cheers.

Carlos.