Database and SQL questions

Can TRIM be used to remove specific text rather than just spaces? I haven’t been able to find anything that would give me the syntax for that, though it’s hinted that it’s possible. In addition, can you specify multiple strings to remove at the beginning of a field, such as LTRIM X or Y from (field)?