Surprisingly, the RENAME (aka REN) command in DOS supports wildcards.
If you had a stack of files called:
You could call:
REN DSC_*.JPG Photo_*.jpg
And it'll replace the text accordingly like:
What's even more surprising is that this solution came from Yahoo answers!