Rtrim cannot trim certain character

[kababoom]

Hi i'm using Oracle 9i has any one encountered this strange problem whereby rtrim cannot trim certain character; for my case i notice it does not trim characters ending wif J or Q while the rest of the character are able to produce the requested result

[debasisdas]

kindly post your query for my reference.

[kababoom]

kindly post your query for my reference.

Hi i'm using this command to trim fields to remove .jpg
MemberNo := UPPER(RTRIM(s1, '.JPG')); -this is a sample code as i'm posting for someone & this is all i've got from her so far but the strange thing is if the field ends wif letter "P" or "J" the result will be SxxxxxP. or SxxxxJ. however if it ends with other letters the query functions correctly.
Is there anything i should look out for?

Thanks for any help

[amitpatel66]

Hi i'm using this command to trim fields to remove .jpg
MemberNo := UPPER(RTRIM(s1, '.JPG')); -this is a sample code as i'm posting for someone & this is all i've got from her so far but the strange thing is if the field ends wif letter "P" or "J" the result will be SxxxxxP. or SxxxxJ. however if it ends with other letters the query functions correctly.
Is there anything i should look out for?

Thanks for any help

What does that XXXX denotes between S and P and S and J??
Can you please post some of the actual data that are getting TRIMMED?