We prefer the former (Do not want the Char(0)).
Is there a connection string setting or a Database Collation that will allow SqlClient to ignore the Char(0) if it is present?
Or any other idea?
Using REPLACE is not an option as we have this problem in numerous tables.
Thanks!