Query - remove braces

Question

I need the below output. Please provide a query for this.

Output

Answer 1

SELECT CASE WHEN charindex('{', col) > 0
       THEN substring(col, 1, charindex('{', col) - 1)
       ELSE col
FROM tbl

The query simply removes all text that comes after the first left brace (and the brace itself), no matter whether this brace is matched by a right brace or not.