DD/mm/yyyy in varchar(max) needs to be converted to yyyymmdd format
That's very complex. It's easier than that. Just run,

ALTER TABLE foo
    ALTER COLUMN dt datetime2 NOT NULL;


Where dt is the name of your varchar date field. Now you have it in a date field, and you can simply,

SELECT convert(varchar, mydate, 112)
FROM foo;