Home Forums SQL Server 7,2000 T-SQL Extract filename from fully qualified path RE: Extract filename from fully qualified path

  • August 17, 2017 at 7:55 am

    #1955652

    Query is almost correct.
    I corrected and now it works for me

    RIGHT([physical_device_name],CHARINDEX('\',REVERSE([physical_device_name]))-1) AS NameOfFile