At 2:53 -0700 5/11/02, impala wrote:
>Hi
>
>I would like a person to search for a surname. If for
>example you have the surnames "Clark", "Williams" and
>"Wilcox" in the database.
>
>e.g. If the person search just for "Wil" the surnames
>"Williams" and "Wilcox" must be displayed. If the
>person se
impala,
Saturday, May 11, 2002, 12:53:20 PM, you wrote:
i> I would like a person to search for a surname. If for
i> example you have the surnames "Clark", "Williams" and
i> "Wilcox" in the database.
i> e.g. If the person search just for "Wil" the surnames
i> "Williams" and "Wilcox" must be disp
Replace your sql select query with these lines:
SELECT LASTNAME, FIRSTNAME, DEPARTMENT
FROM EMPLOYEES WHERE LASTNAME LIKE '%varLastName%'
It makes caseinsensitive search, so when varLastName is 'C'
it will find Clark and Wilcox ,because they contain letter 'C'.
Also you can use 'varLastName%' to
G'day Nic
> Just by typing part of the word ,how can I make a
> search in databse possible by using something like
> SELECT in SQL?
Seems like you just need the % wildcard character
SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE
"%searchdata%";
cheers
kim
