Query needed

Hi Experts,

I am in need of a Query

i have a table with different columns

-

id | name | date | path

-

10 | xyz | 10.12.2008 | C:\system\new\hello.pdf

20 | abc | 25.04.2008 | C:\data\old\one.jpg

and so on...

I want to diplay all of the fileds and in the last column that is the path column, I want the extention ( i.e PDF or JPG or so on) in a different new column and the file name (i.e hello or one so on) in a different new column and the path ( c:\system\ new or son on) in a different new column.

so it like all the 3 in 3 different columns..

Thanks & Regards,

Raj