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',
Loading
Krishna GaradPosted Mar 7, 2011, 2:19 AM
declare @cat varchar(40);
SET @category='MotorCycle / ATV Audio(0)';
SET @cat = (SELECT LEFT(''''+@category+'',CHARINDEX('(',''''+@category+'')-1+')'))
Krishna GaradPosted Mar 7, 2011, 2:24 AM
PankaJ DPosted Mar 7, 2011, 2:23 AM