How to find Hidden special character in a column at end?

Question

EXAMPLE COLUMN VALUES ARE 1 2 3 null ..... WHERE I HAD SPACES AT BESIDE NUMBERS AND null  HOW TO FIND WHETHER THAT IS WHICH SPECIAL CHARACTER?

Nitin Sontakke · Answer

It's complicated. First you can fire a query like: select column  len( column ) from table This way visually you can find that there is an extra char because even for value '1' it will show length 2 which is obviously wrong. After than you will need to loop through each char in a column and print it's ascii value.