SELECT TOP 1 REPLACE(name, '*Deleted*', '' ) FROM OBJ_R) AS lastname and SELECT SUBSTRING(NAME FROM 1 FOR POSITION(',' IN NAME)-1) FROM OBJ_R
而不是删除贝勒， 妮可，应该只有贝勒。我试过这个：
SELECT SUBSTRING(NAME FROM 1 FOR POSITION(',' IN NAME)-1) FROM OBJ_RESOURCE
hgtggwj01#
可以嵌套函数：
SUBSTRING(REPLACE(name, '*Deleted*', '' ) FROM 1 FOR POSITION(',' IN REPLACE(name, '*Deleted*', '' ))-1) FROM OBJ_R
1条答案
按热度按时间hgtggwj01#
可以嵌套函数：