22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 1 TQCI_FileUrl,
CHARINDEX('|', TQCI_FileUrl),
REVERSE(LEFT(TQCI_FileUrl,68))
--REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)))
--REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)-1))
FROM tqci_tqci
WHERE tqci_modelstation_id=15406
ORDER BY tqci_rev DESC
SELECT TOP 1 TQCI_FileUrl,
CHARINDEX('|', TQCI_FileUrl),
--REVERSE(LEFT(TQCI_FileUrl,68))
REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)))
--REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)-1))
FROM tqci_tqci
WHERE tqci_modelstation_id=15406
ORDER BY tqci_rev DESC
SELECT TOP 1 TQCI_FileUrl,
CHARINDEX('|', TQCI_FileUrl),
--REVERSE(LEFT(TQCI_FileUrl,68))
--REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)))
REVERSE(LEFT(TQCI_FileUrl,CHARINDEX('|', TQCI_FileUrl)-1))
FROM tqci_tqci
WHERE tqci_modelstation_id=15406
ORDER BY tqci_rev DESC
DECLARE @STR NVARCHAR(200)
SET @STR='<PRE>..\UploadFile\TQCIUploadFiles\LIK\201407\201407230922117549.pdf|..\UploadFile\TQCIUploadFiles\LIK\201407\201407230922103378.xlsx</PRE>'
SELECT TOP 1 @STR,
CHARINDEX('|', @STR),
--REVERSE(LEFT(@STR,68))
--REVERSE(LEFT(@STR,CHARINDEX('|', @STR)))
REVERSE(LEFT(@STR,CHARINDEX('|', @STR)-1))
REVERSE(LEFT(@STR+'|',CHARINDEX('|', @STR+'|')-1))
少加了一个"|"REVERSE(LEFT(@STR+'|',CHARINDEX('|', @STR)-1))
@STR+'|'--这里改改再试
CREATE TABLE TEST1
(
FileUrl NVARCHAR(200)
)
insert into TEST1 values('<PRE>..\UploadFile\TQCIUploadFiles\LIK\201407\201407230922117549.pdf|..\UploadFile\TQCIUploadFiles\LIK\201407\201407230922103378.xlsx</PRE>')
SELECT FileUrl,
CHARINDEX('|', FileUrl),
--REVERSE(LEFT(FileUrl,68))
--REVERSE(LEFT(FileUrl,CHARINDEX('|', FileUrl)))
REVERSE(LEFT(FileUrl,CHARINDEX('|', FileUrl)-1))
FROM TEST1