>Is there a function that will create a sortable date string like VFP's DTOS(). It produces a string in the format 'YYYYMMDD'?

The CONVERT() function allows to control datetime conversion to a string with 3rd parameter

SELECT CONVERT(char(8), getdate(), 112)