Hi Everyone!

I have got a C# project and some data like:

Thinness (n.)
Slenderness (n.)
A fat lot
Hefty (a.)
Tucking of loincloth
I want these data just like that below

Thinness
Slenderness
A fat lot
Hefty
Tucking of loincloth
I tried

UPDATE    dic
SET  english = LEFT(english, CHARINDEX('(', english) - 1)
WHERE  (CHARINDEX('(', english) > 0)
But I get error:

Token in error LEFT

How can I handle that?

Thanks in advance