What’s the best way to identify hidden characters in the result of a query in SQL Server (Query Analyzer)?
Create a function that addresses all the whitespace possibilites and enable only those that seem appropriate: SELECT dbo.ShowWhiteSpace(myfield) from mytable Uncomment only those whitespace cases you want to test. For example: CREATE FUNCTION dbo.ShowWhiteSpace (@str varchar(8000)) RETURNS varchar(8000) AS BEGIN DECLARE @ShowWhiteSpace varchar(8000); SET @ShowWhiteSpace = @str SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(32), ‘[?]’) SET … Read more