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%' ?? 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