Sql Server
From this string
'D:\DBF_004_11_12_14_V11\FDMS\024.dbf' we need to extract the file name 024
Declare @fileName Varchar(500)set @fileName = 'D:\DBF_004_11_12_14_V11\FDMS\024.dbf'select LEFT(RIGHT(@fileName , charINDEX('\', reverse(@fileName )) - 1), 3)
From this string
'D:\DBF_004_11_12_14_V11\FDMS\024.dbf' we need to extract the file name 024
Declare @fileName Varchar(500)set @fileName = 'D:\DBF_004_11_12_14_V11\FDMS\024.dbf'select LEFT(RIGHT(@fileName , charINDEX('\', reverse(@fileName )) - 1), 3)
No comments:
Post a Comment