Hi all ,
I have table where users are allowed to enter data from excel sheet but while viewing it in application due to non key board values are like ¶, ã, £
the validation getting failed and values are not loaded kindly help me in finding those non key board values , as data has been already loaded i need to find the data with non key board values .
i have written the query for one values but i need to find it for all the other values which are not part of key board
select * from note where text like '%'|| chr(1) ||'%';