Skip to content
Advertisement

How to take some value from value in one column in Teradata SQL?

I have table in Teradata SQL like below:

The first value is always: “O|” then there is 4 numbers and so on… I need to create new column only with these 4 numbers code, so as a result I need something like below:

How can I do that in Teradata SQL ?

Advertisement

Answer

Use STRTOK

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement