selecting by the first letter of a lastname 1

[PTmon]

Hi, I'm writing a simple page to list contact information. I need to query a field called lname from and url variable. list.cfm?lname=A

What I want to do is list all the lastnames that begin with the letter specified in the url variable. I"m not sure how to write the query. Your help would be appreciated
thanks,
PT

http://mahon.homeip.net/remember

 

[imstillatwork]

in the where clause do this:

WHERE lname LIKE '#URL.LName#%'
that will find url string at the LEFT of the field,

WHERE lname LIKE '%#URL.LName#'
that will find url string at the RIGHT of the field,

WHERE lname LIKE '%#URL.LName#%'
that will find url string at the ANYWHERE in the field

make sense?

 

[PTmon]

It does and I thank you!

http://mahon.homeip.net/remember