Does anyone know how to do the equivalent of the VFP occurs function in SQL Server 7.

For example, in my data field bigstring contains 'AAABCCCDD'

occurs('A',bigstring)=3
occurs('ABC',bigstring)=1

Thanks