database

[happy camper]

now that i have my employee search page working i need one
more bit of help. now the intranet has a page where
employees can look up other employees by last name but
they have to type in complete last name. i need help with
a statement that can get names by ay typed in data. so if
i type "smi" i get everyone who has "smi" in their name
somewhere.

 

[Kathleen Anderson [MVP - FP]]

From: http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

a.. Using the Begins With comparison:
a.. If you choose Use this search form field, the SQL statement looks like
this:
SELECT * FROM Categories WHERE (CategoryName LIKE '::CategoryName::%')

b.. If you manually enter the Value, the SQL statement looks like this:
SELECT * FROM Categories WHERE (CategoryName LIKE 'text string%')