Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Remove characters before"-" in Teradata

  1. Forget Code
  2. Teradata
  3. Remove characters before"-"
Suppose we have a field which is having a char/varchar value '375472336257-2'

If we want remove the characters before '-' then, the SUBSTRING function can be written as 

SELECT SUBSTRING(myField,POSITION('-' IN myField)+1)  FROM table