Wasnt sure where to put this question, but VB users sometimes know a bit of SQL:
Just a quick "know it or you dont question".
Is there a command to count the number of instances of a specified character or string in a field?
Thought i'd ask before I spend the time writing my own, however, if I do ill post it here.
Any help would be much appreciated.
Additional: Saying that, I can't seem to find the sql equivalent of the instr command to make my own function either!