SQL Pattern Matching & Script

2002-05-12 Thread impala
> >Thanks for answering > >"search character by character" 11 May 2002 > >Making use of a HTML textfield which sends text to > >variable 'varLastName'. > >How do I concatenate the variable > part('varLastName') > >with > >the % part is it something like: > > > >SELECT LASTNAME, FIRSTNAME, > >DEP

SQL Pattern Matching

2002-05-11 Thread impala
Thanks for answering "search character by character" 11 May 2002 Making use of a HTML textfield which sends text to variable 'varLastName'. How do I concatenate the variable part('varLastName') with the % part is it something like: SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE LAS

search character by character

2002-05-11 Thread impala
Hi I would like a person to search for a surname. If for example you have the surnames "Clark", "Williams" and "Wilcox" in the database. e.g. If the person search just for "Wil" the surnames "Williams" and "Wilcox" must be displayed. If the person search just for "C" the surname Clark must be d