Replacement of Char(2) in Select from SQL server

[Mads Westen]

I have a user who uses Access to Select data from a SQL server hosting a ERP
applicatioin.
The ERP app. uses Char(2) in empty text fields.

My user doen't want to have the Char(2) out in his Access reports. How can I
prevent that?
I have been looking at creating a View on the SQL 2005 server, but this
solution is timeconsuming because of 20 tables with x text fields with just
as many Replace functions.

Best regards
Mads

 

[Douglas J. Steele]

I suspect that the Replace route is your only option.