How can I get the results of a find back without the pathname

for example if i do

find ../../ -name \*.sql

i dont want to see

directory/directory/filename.sql

I only want to see filename.sql

Try:
find ../../ -name \*.sql -print | sed 's=.*/=='

Cheers perdarbo. This seems to work.

What exactly is this doing? Are there any shortfalls?

That sed command deletes everything up to the last slash, which is pretty much what you asked for.

There are no "shortfalls" that I know of. As far as I know, it is right on the mark.