0

I have a field in a table where the data is one of the following:

  • ABC" D
  • "Add"b"

How can I ignore the " character?

I am new to netezza and have some sql knowleged

Metalskin
  • 3,998
  • 5
  • 37
  • 61
user3219027
  • 1

1 Answers1

1

You can solve this many different ways. I recommend translate

select  translate(test.test_data,'"','')
from (select 'ABC" D' as test_data
union all
select '"Add"b"') test
Niederee
  • 4,155
  • 25
  • 38