declare @s1 char(10), @s2 char(10)
select @s1 = CHAR(160) + 'WDT' + CHAR(160)
select @s1, '[' + LTRIM(RTRIM(@s1)) + ']'

select @s2 = CHAR(32) + 'WDT' + CHAR(32)
select @s2, '[' + LTRIM(RTRIM(@s2)) + ']'

SELECT DISTINCT 
	[Code] = ASCII(SUBSTRING(LTRIM(columnName), 1, 1)), 
	[Character] = '[' + SUBSTRING(LTRIM(columnName), 1, 1) + ']'
FROM tableName
WHERE (columnName LIKE '%WDT%')

SELECT colname,CAST(colname as varbinary(5)) 
FROM tablename 
WHERE colname LIKE '%WDT' 
AND colname <> 'WDT' 

Far away is close at hand in the images of elsewhere.

Anon.