I need to make a script to convert all user records into a table in this format (single field):
INFORMATICA\desenvolvedor
ADMINISTRACAO\contador
That is, before the uppercase bar and then the lower bar. How to do this in SQL Server?
Currently the records are like this (single field):
informatica\desenvolvedor ou
INFORMATICA\DESENVOLVEDOR