> >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 LASTNAME LIKE
> >'varLastName'&%
> >OR is it something like 'varLastName%' ??
>
> Depends on your scripting language, and you haven't
> mentioned what that is.
I'm making use of ASP and JScript
> >Previous Answer:
> >Use a SQL pattern and the LIKE operator. For
> example
> >"C%"
> >matches any value beginning with "C". "Wil%"
> matches
> >any value beginning with "Wil".
> >
> >Some of the other responses you've gotten indicate
> >that
> >you should use "%var%", but that will match values
> >that
> >contain var anywhere, not just at the beginning.
>
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
