I have a table it has a country field
I need to return the fields with the FIRST Letter for ex C
here is my query:
strAlpha="C"
if strAlpha <> "" then
set rsCountry=server.createobject("adodb.recordset")
RsCountry.Open "SELECT * from cmm_country where country_name like '%" & strAlpha & "'",conn,3,3
end if

Try reversing that:
SELECT * from cmm_country where country_name like '" & strAlpha & "%'",

Woody Z http://www.learntoprogramnow.com

thanks a lot.it worked