34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @T TABLE(ID INT, TYPE VARCHAR(10))
INSERT @T SELECT 1, '1|6'
INSERT @T SELECT 2, '1|45'
INSERT @T SELECT 3, '1|892'
SELECT RIGHT(TYPE,LEN(TYPE)-CHARINDEX('|',TYPE)) FROM @T
/*
----------
6
45
892
*/
---------------------------------
-- Author: liangCK 小梁
-- Date : 2008-11-14 15:20:46
---------------------------------
--> 生成测试数据: @T
DECLARE @T TABLE (ID VARCHAR(2),TYPE VARCHAR(5))
INSERT INTO @T
SELECT '1','1|6' UNION ALL
SELECT '2','1|45' UNION ALL
SELECT '3','1|892'
--SQL查询如下:
SELECT ID,
RIGHT(type,CHARINDEX('|',REVERSE(type))-1) AS type
FROM @T
/*
ID type
---- -----
1 6
2 45
3 892
(3 行受影响)
*/
SELECT ID,
RIGHT(type,CHARINDEX('|',REVERSE(type))-1) AS type
FROM tb