Re: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Marjolein Katsma
At 16:10 2002-03-06, BadgerBay wrote: >Hello, > >This is a good question for when you are sipping coffee or tea and are >inspired to write some code. I require additional functionality for my SQL >search: > >MY CURRENT SEARCH > >SELECT ID, Authors, Year, Title FROM libraryTable >WHERE (Authors LIK

RE: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Adam
ailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: SQL coding: Finding singular when search with plural. Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for m

SQL coding: Finding singular when search with plural.

2002-03-06 Thread BadgerBay
Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '%" + varAuthor + "%') OR (Keywords LIKE '%" +