I use the "%" for a wildcard in all the asp pages I've ever written. So something like the following should work. select * from items where KeyWords like "quick%" found a little tidbit of info here http://hkkk.fi/~dbproj/sqlexamp.htm -Josh