Painting-Like Look

I was wondering on how to do a painting-like look in a picture.
I use Adobe Photoshop CS2.