• Chris Morris (9/24/2008)


    SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 102), '.', '')

    You dont need additional replace function

    See my first reply 🙂


    Madhivanan

    Failing to plan is Planning to fail