* "The Sculptor's Studio" (title of a book or art exhibit)
* "Michelangelo, the Sculptor" (referring to the famous artist)
However, you don't capitalize "sculptor" when it's used as a general noun describing someone's profession:
* "The sculptor was working on a new piece."
* "She is a talented sculptor."
Let me know if you have any other capitalization questions!