0

I am trying to take out names from a table where name does not contain characters or numbers.

Name Flag
Abc    0
124    0
£%     1
AB÷    0
17     0
*&     1

What function to be used in Teradata to achieve the desired result?

Best,

dnoeth
  • 59,503
  • 4
  • 39
  • 56
Leon35
  • 25
  • 4
  • Yes, as the title says you could use REGEXP_SIMILAR to identify rows to keep. Be aware that REGEXP_SIMILAR has to match the entire string - you can think of it as always adding ^ before and $ after the supplied pattern string. Or you can use REGEXP_INSTR to identify rows to exclude. – Fred Dec 14 '22 at 16:45
  • `regexp_similar(str,'.*[^0-9a-zA-Z].*')` looks for any character not in the list – dnoeth Dec 14 '22 at 21:35

0 Answers0