When I execute this code Syntax error is occured.
declare @category
varchar(40
);
declare @cat
varchar(40
);
SET @category
='MotorCycle / ATV Audio(0)';
SET @cat = SELECT LEFT(''''+@category+'',CHARINDEX('(',''''+@category+'')-1)
Incorrect syntax near the keyword 'SELECT',