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
>How do I concatenate the variable part('varLastName')
>the % part is it something like:
>SELECT LASTNAME, FIRSTNAME,
>DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE
>OR is it something like 'varLastName%' ??
Depends on your scripting language, and you haven't
mentioned what that is.
>Use a SQL pattern and the LIKE operator. For example
>matches any value beginning with "C". "Wil%" matches
>any value beginning with "Wil".
>Some of the other responses you've gotten indicate
>you should use "%var%", but that will match values
>contain var anywhere, not just at the beginning.