SELECT TOP 10 MajorName ,SUBSTRING( MajorName,1 ,CHARINDEX('(',MajorName)-1 ) AS 'MajorShortName' FROM dbo.TableA WHERE MajorName LIKE '%(%'
SUBSTRING( 字段名,1 ,CHARINDEX('(',字段名)-1 )
运行结果如下:
SELECT TOP 10 MajorName ,SUBSTRING( MajorName,1 ,CHARINDEX('(',MajorName)-1 ) AS 'MajorShortName' FROM dbo.TableA WHERE MajorName LIKE '%(%'
SUBSTRING( 字段名,1 ,CHARINDEX('(',字段名)-1 )
运行结果如下: