Peter J. Boettcher — Mon, 08 Jan 2001 14:05:23 +0000

PDavis,

It depends on how you setup your database. The COUNT(*) function works on a row basis, not field. So if you had a table called Person with the fields FirstName & LastName and 20 records containing a first name of 'john', the following statement:

SELECT COUNT(*) AS Expression, FirstName
FROM Person
WHERE (FirstName = 'john')
GROUP BY FirstName

Would return:

20, john

From the sounds of it you want to search multiple fields within the same row for a particular string, Count won't work for this. You would have to search for the string, then setup a counter and a loop that counts the number of matches for each field.

Mark Hensler — Sat, 06 Jan 2001 05:01:04 +0000

link didn't work for me....