Sql Query to Retrieve Path and file Name -

Sql Query to Retrieve Path and file Name -

i need retrieve file name extension database column.

example : c:\abc\bde\hyr\gff\test.txt

i need result test.txt

and c:\abc\bde\hyr\gff

please help

thanks

you can seek this.

select reverse(left(reverse(columnname),charindex('\',reverse(columnname))-1)) filename, reverse(right(reverse(columnname),len(reverse(columnname)) - charindex('\',reverse(columnname)))) directory

sql