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,