c# - Remove all after certain character -

c# - Remove all after certain character -

i have got c# project , info like:

thinness (n.) slenderness (n.) fat lot hefty (a.) tucking of loincloth

i want these info below

thinness slenderness fat lot hefty tucking of loincloth

i tried

update dic set english language = left(english, charindex('(', english) - 1) (charindex('(', english) > 0)

but error:

token in error left

how can handle that?

the left function apparently not supported in sql server ce, can utilize substring instead.

i did test , worked fine:

class="lang-sql prettyprint-override">update dic set english language = substring(english, 1, charindex('(', english) - 1) (charindex('(', english) > 0)

c# sql-server-ce