>We've got a data file that has dates in 'dd-mm-yyyy (time)' format (and coming in as a string) and need them in 'standard amurican' 'mm-dd-yyyy (time)'.
>
>What's the best way to do this conversion?

Are you looking to do the conversion in SSIS or something? How is the file getting loaded?

Or is it stored in the table as a string in that format?