DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: special characters

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    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 ..

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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
  •  


Click Here to Expand Forum to Full Width