Counting specific instances of a character in a string

UDA

Counting specific instances of a character in a string

As a newcomer to Teradata SQL is there a way of counting how many of a particular character occurs in any given string?

e.g. Count 'A' in 'ABRACADABRA' gives the result 5

Thanks