I want to trim trailing 'A' from "ASIAAAAAA".

I do not think to exist such a function in Sybase or any other RDBMS language. Plus that I did not understand exactly what the result should be: "ASI" or "ASIA".

I am although pretty sure you may write a T-SQL function that:
- has a string parameter
- remove any spaces
- reads the last letter of the string
- WHILE the last but one letter is equal with the previously read one, remove the last letter from the string
- returns the remaining string

It should be "ASI"...The function should work as ltrim() or rtrim() in oracle.

Unfortunately no in ASE. There is an rtrim, but it only trims space. Theres no provision to trim a user defined character.

There is str_replace, but again, it doesnt accept wildcards. So, its basically all 'A's in a string.

Maybe a feature request for Sybase.