January 23, 2015 at 4:43 am
Hi,
I am selecting only one field from the table but it returns duplicate for one value.
All the values in table
ans_val1
---------------
No acc3ss
No access
No access
No access
No access
No access
No access
No access
No access
SELECT STATEMENT
--------------------------------------------
SELECT DISTINCT
LTRIM(RTRIM(ans_val1)) AS Answer
FROM FactTenancyAssesment
ORDER BY Answer
RESULT
------------
No acc3ss
No access
No access
Can anyone please help? I have also tried the group by but same results.
Thanks
January 23, 2015 at 5:44 am
I found the answer there was an invisible control character in one of the values.
January 23, 2015 at 5:55 am
great. what hidden character?
January 23, 2015 at 6:58 am
It was CHAR(9) for tab.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply