I have a column that stores data in the following pattern #campo#=valor;#campo#=valor
(and so on)
ex: '#aaaa#=1111;#bbbbb#=2222;#cccc#=33333'
However, they added ;
within the value and I wanted to find them, I need to find the records that have ;
and soon after anything other than #
Ex of record to be found: '#aaaa#=1111;#bbbbb#=2222;#cccc#=33;333'
The database is MSSQL.