Workaround for Items filed in Results which contain a Comma ?

I still don't have access to thousands of files which contain a comma.
PaperPort 9 and 10 name files by default like this:
August 22, 2007-Document-008.pdf
When Synapse files a document it prefixes the item with the patient's synapse ID for instance:
784-August 22, 2007-Document-008.pdf

I could remove all the commas and replace them with underscores (http://www.bulkrenameutility.co.uk)

Is there a way to rename the thousands of files which contain commas in the synapse tables ?
Some SQL statement ?
A simple replacement of all , with _ ?

I don't know how you'd do that in SQL if at all, but it could be scripted in Rebol.

I guess I need to look again to see why this issue is occurring.

All I need to do is change this filename.
Replace the commas in the filenames with an underscore.
Isn't the filename in an SQL table ?

SQL is a SET manipulation language.

How can I fix this then ?

My staff and I don't have access to thousands of Results.

Well, I don't think that's quite true

1. You have the originals in PP
2. You can setup a slave PC to view them
3. The file is still downloaded .. but Acrobat doesn't like to view them with commas in the file name so you can view them by finding in the www directory

Your options are
1. Script a rename in the files database
2. Wait for us to find a fix but my priority is currently the web portal
3. If it's urgent, you can sponsor a fix

Where are result's filename stored ?

Commas in Windows file naming isn't that crazy.