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#
可以嵌套函数: