Subject Importing and parsing data in stored procedure
Author Rick DeBay
I have a table that contains dates and times, but they're stored as
varchar in either yyyymmdd, yymmdd, or hhmmss format. I'm importing
them to another table so I can correctly store them as a Date or Time.
Can I do this with a stored procedure? If so, can someone let me know
what I need to do to parse the fields?

Rick DeBay
Senior Software Developer
RxStrategies.net