hi friends

below mentioned query doesn't retrieve records .

select * from upload_volume WHERE USER_ID = 'annette.beyer' AND LTRIM(RTRIM(VOL_ID)) = 'SYN-001'

but if i comment
select * from upload_volume WHERE USER_ID = 'annette.beyer' ;

it shows above records with SYN-001

I AM SURE THERE IS SOME CONTROL cHARACTER ^M

HOW TO QUERY for any control characters present in particular column ..