Greg Bowser Sun, 23 Mar 2008 17:54:29 -0700
Sounds like you want something like the following: SELECT DISTINCT category FROM `contacts` WHERE state='california';
--GREG