Counting Multiple Strings In a Single Column

Atmosphere
02-10-2004, 07:30 AM
I have a single column and i would like to count how many times a known finite set of strings appear in that column.. I hope to achieve this in a single query

Issvar
02-10-2004, 08:11 AM
Count records with one or more matching strings:
SELECT COUNT(Column) FROM Table WHERE Column IN ('String 1','String 2','String 3','etc.')

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum