34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT RIGHT(CatalogID,4) as newCatalogID FROM demandUnits WHERE CatalogID LIKE '%M';
SELECT max(cast(substring(CatalogID,2,4) as int)) as newCatalogID FROM demandUnits WHERE CatalogID LIKE 'M%';
SELECT substring(CatalogID,1,5) as newCatalogID FROM demandUnits WHERE CatalogID LIKE 'M%';