Function does not support collation

Question

I'm trying to use the UPPER/LOWER function in Snowflake but I'm receiving the error 'Function UPPER does not support collation'.

Is there any way I can use the UPPER/LOWER functions or is there an alternative?

Thanks

Answer 1

Can you try the COLLATE function for this?

https://docs.snowflake.net/manuals/sql-reference/functions/collate.html

This suggests that you can upper case a character within a collation to check for items being the same. Something like: COLLATE(MyField,'en-upper')

Thanks

Ben