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

Re: SQL Pattern Matching

2002-05-11 Thread Paul DuBois
At 13:43 -0700 5/11/02, impala wrote: >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,

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