I need some help 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 Management Studio).