Similar to your other thread if it's always "AMOUNT: " then use replace. If you must use 3 replaces, one for "AMOUNT:" one for "$" and one for all spaces.
A better way is this:
substring is a functions that requires as input:
that column
from where to begin
where to end
if you use 3 replaces each time on the column, that's 3 additional function calls.
it adds overhead.
the preferred method is this: using instr (a function that returns the position of a string in another string). it requires as input a column and the string to find.
an example:
substr(active.note,instr(active.note,'$')+1)
that's it. you don't have to provide the third parameter for substr if you want the rest of the string (length of column).