I need help using a string variable in an update statement.
A little background:
I have a call center application that imports spreadsheets(workorders) from outside contractors. The file that they send back in will be in the following format. 20070709143618Ticket193596.xls (yyyy mm dd hh mm ss)...