How to do the case insensitive group by

how to conduct a case insensitive search in Cloud SQL server, i tried couple ways like

select column_name, upper(column_name) from table_a group by upper(column_name)

select column_name, hex(column_name) from table_a group by hex(column_name)

always give me case sensitive result!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.