Understanding the Issue with charindex and Substring in SQL Server: A Solution to Extracting Substrings between Brackets