I have Table in Teradata SQL like below:
col1
-------
1234 Odp Berlin
5643 Odp Warsaw
9984 Odp Madrid
And I would like to delete “Odp ” from “col1” and based on it create “col2”, so as a result I need something like below:
col1 | col2
---------------------
1234 Odp Berlin | 1234 Berlin
5643 Odp Warsaw | 5643 Warsaw
9984 Odp Madrid | 9984 Madrid
How can I do that in Teradata SQL ?