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
Counting Multiple Strings In a Single ColumnAtmosphere 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