Remove '(' after all of the characters-CodePudding

Iron plate (China)
Solid wood plate (Japan)

As long as I get the
Iron plate
Solid wood tray

(behind me not

CodePudding user response:

SELECT the LEFT (' iron plate (China), CHARINDEX (' (', 'iron plate (China)') - 1)

CodePudding user response:

 
- if the brackets in front can go to remove 
Declare @ FName varchar (200) 
The Set @ FName='iron plate (China) iron plate' 
Select the REPLACE (@ FName, substring (@ FName, CHARINDEX (' (' @ FName), CHARINDEX ('), the substring (@ FName, CHARINDEX (' (' @ FName), 99))), ' ')