SQL Server Compare similar tables with query

Simple concept we are basically doing some auditing, comparing what came in, and what actually happened during processing. I am looking for a better way to execute a query that can do side by side table comparisons with columns that are slightly differnt in name and potentialy type.

DB Layout:

Table (* is the join condition)

Log (Un-altered data record.)
- LogID
- RecordID *
- Имя
- Дата
- Адрес
- Продукты
- и т. д.

Аудит (запись постобработки)
- CardID *
- CarName
- DeploymentDate
- Адрес доставки
- Параметры
- etc.

For example this would work if you look past the annoying complexity to write, and performance issues.

The query just joins the left and right and selects them as strings. Showing each field matched up.

select 
  cast(log.RecordID as varchar(40)) + '=' + cast(audit.CardID as varchar(40),
  log.Name+ '=' + audit.Name ,
  cast(log.Date as varchar(40)) + '=' + cast(audit.DeploymentDate as varchar(40), 
  log.Address + '=' + audit.ShippingAddress,
  log.Products+ '=' + audit.Options
  --etc
from Audit audit, Log log
  where audit.CardID=log.RecordId

Which would output something like:

1=1 Test=TestName 11/09/2009=11/10/2009 null=My Address null=Wheels

This works but is extremely annoying to build. Another thing I thought of was to just alias the columns, union the two tables, and order them so they would be in list form. This would allow me to see the column comparisons. This comes with the obvious overhead of the union all.

ie:

Log 1 Test 11/09/2009 null, null
Audit 1 TestName 11/10/2009 My Address Wheels

Any suggestions on a better way to audit this data?

Let me know what other questions you may have.

Additional notes. We are going to want to reduce the unimportant information so in some cases we might null the column if they are equal (but i know its too slow)

  case when log.[Name]<>audit.[CarName] then (log.[Name] + '!=' + audit.[CarName]) else null end

or if we are doing the second way

  nullif(log.[Name], audit.[CarName]) as [Name]
  ,nullif(audit.[CarName], log.[Name]) as [Name]