Select Staement Help [message #372055] |
Mon, 08 January 2001 09:31 |
David
Messages: 110 Registered: November 1998
|
Senior Member |
|
|
Hello,
I don’t know if this is possible but if anyone knows how to do this I would appreciate any help I can get. I need to create a select statement for my visual basic program that if the user enters a word such a "Business" it will find any company with the word "Business" no matter where the word ‘Business” falls. So it will find for example "Business Solutions", "Technical Business", Complete Business Solutions, and ect. My select statement current looks like this:
SELECT open_num, client, matter, opposing_p FROM lrwhdata WHERE client = '" & gWordClientSearch & "%' ORDER BY client;
Thank you,
David
|
|
|
Re: Select Staement Help [message #372056 is a reply to message #372055] |
Mon, 08 January 2001 10:52 |
spdevalla
Messages: 7 Registered: December 2000 Location: Rhode Island
|
Junior Member |
|
|
Try like this
SELECT open_num, client, matter, opposing_p FROM lrwhdata WHERE client like
'%" & gWordClientSearch & "%' ORDER BY client;
|
|
|
Re: Select Staement Help [message #372074 is a reply to message #372055] |
Tue, 09 January 2001 03:53 |
GK
Messages: 22 Registered: January 2001
|
Junior Member |
|
|
HI THIS SHOULD ALSO WORK TOO GOOD
SELECT open_num, client, matter, opposing_p FROM lrwhdata WHERE INSTR(client,'" &gWordClientSearch & "')>0 ORDER BY client;
|
|
|
|