I need some hel with a regex in SQL.
I need to make a regex to check if a string contains a substring like this: [—– (to)]
This regex have to find a substring that start after “[” and that ends before ” (to)]”.

I need that the substring doesn’t contains spaces.
This regex has to work in SQL server (I am testing in Microsoft SQL Server Managment Studio)