I have a table that imports data from text files, and the dates come
in as YYYYMMDD into a varchar column.

I need to compare those dates to a column in an existing table that is
date format YYYY-MM-DD


I was thinking that CONVERT(DATETIME,temp_table_field) =
'existing_table_field' but keep getting a syntax error.