Your solution worked perfectly for my last scenario (convertng MMDDYY to YYYYMMDD)

Now I have the inverse scenario.. I need T-SQL to convert the character 8 format "YYYYMMDD" to a character 6 format "MMDDYY"

eg. 20070918 needs to be converted to 091807

(I realize DATE formats are desired but this is part of a filename value that I am dynamically building based on received parameters)

Any assistance is greatly appreciated.