Am I on the right track?

Started designing a View (MS Access can link to a view). The Oracle data is Read-Only.

The Oracle data residing in SQL Server will be where the View is run from.

Tried this and it looks promising:

SELECT TOP 1000 (CAST( [Audit_ID] as varchar(5) ) ) as Audit_ID

,[TAXPAYER_NAME]

,[DIVISION_ID]

,[STATE_ABBRV]

,[STATE_NAME]

,[COUNTY_NAME]

My reading indicates that CAST can only be used on fields with no Nulls or no Non-Numeric values.

A PK is a good candidate for CAST