Replace accented characters

1

Hi everyone,

Is there any function in Dremio to replace accented characters? Similar to that of MS SQL Server

SELECT ‘áéíóú’ COLLATE SQL_Latin1_General_Cp1251_CS_AS;
→ aeiou

Thank you.

2

@borasy Have you tried to use regexp_replace
SELECT regexp_replace('JUAN ROMÄNí','[[=A=]]+','A' )