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 search just for C the surname Clark must be
displayed.
I
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
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%'
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 displayed. If the
i
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 search just for C the