The lack of this function forced me to come up with a quick and dirty solution:
:str as "string",
:chr as "character",
length(:str) - length(translate(:str,chr(0)||:chr,chr(0))) as "count"
Note: this works on the assumption that you are never going to count character zero.
Anyone else with a better/faster idea?