kevin, use LIKE > Problem is, I've never really found a good listing for > [Access SQL extensions, functions] String Manipulation Functions in Access http://office.microsoft.com/assistance/2002/articles/ac_TextFunctionsAccess .aspx Access query language elements http://www.bris.ac.uk/is/selfhelp/documentation/acc-r4/acc-r4.htm SQL Language Reference http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/h tml/output/F1/D2/S5A318.asp Access SQL http://users.starpower.net/rjhalljr/Serve/AccSql/sql.html Microsoft Access Misc. Tips http://www.bpro.com/Misc/MC_date.htm Dates and Times in Access http://www.bpro.com/Misc/MC_date.htm DevGuru Jet SQL Quick Reference http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html Reserved Words for Various Databases http://www.macromedia.com/v1/handlers/index.cfm?ID=22056&Method=Full Your First Database http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial3.h tml that last one might be a good place to start, kevin rudy