Clever Geek Handbook

Removing interfunctional symbols

Im looking for a way to remove an interval in varchar2. This means I want to get "Marian" from "Mariana" and "Blueberries" from "Blueberries" Thank you for any help or suggestion Ondrej

+3


source to share


1 answer 


with x as (
  select 'Černický' name from dual union all
  select 'Marián' from dual
)
select convert(name, 'US7ASCII')  
  from x;


will work for any name where there is a matching replacement character in the US7ASCII character for the corresponding character. This is not necessarily the case for every possible character - Õ and Ø, for example both will be converted to a question mark (?). But this works for both of your examples.

+1


source






More articles:


All Articles