I have a table with names in it such as "Admin 1", "Admin 2", "Admin 3" etc and wish to count how many entries contain the text Admin. Could somebody help me please, its probably very simple but I am stumped.[/i][/b]
Thankyou very much Brian, I had a go at wildcards ( hangover from some basic programming a long time aga, but I must have been doing something wrong because it works like a treat. Thank you I knew it would be a simple answer but you have saved me a lot of time.