Posted by himilecyclist on 05/16/06 18:29

I just figured it out. The following code does just what I need:

WHERE CONCAT(RPAD(Last, 50, ' '),
RPAD(First, 50, ' '),
RPAD(Middle, 50, ' ')) >=
CONCAT(RPAD('$_POST[txtSrchLastName]', 50, ' '),
RPAD('$_POST[txtSrchFirstName]', 50, ' '),
RPAD('$_POST[txtSrchMiddleName]', 50, ' '))";

Thanks again for the response!

• Next in forum: Re: DOM question - visiting a node's children?
• Prev in forum: Re: Getting the actual URL in browser when
• Thread view: Re: Retrieving and sorting names from MySQL

[Reply to this message]