I have a space on the right side so changed the query accordingly . but afraid it shows no records.

SELECT DISTINCT

[Code] = ASCII(right(LTRIM(valuecode), 1)),

[Character] = '[' + right(LTRIM(valuecode), 1) + ']'

FROM ListOfValues

WHERE (valuecode LIKE '%WDT%')

-- 32,[ ]

SELECT valuecode,CAST(valuecode as varbinary(4))

FROM ListOfValues

WHERE valuecode LIKE 'WDT%'

AND valuecode <> 'WDT'

-- No Records