-
special characters
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 ..
-
sorry to bother you with this question
there is some control character .
came to know with following query ...
select vol_id, ascii(substr(vol_id, 8, 1)) from upload_volume ;
chr(13)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|