Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS
Thread ID: 189266 Message ID: 189278 # Views: 1 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, August 14, 2008 8:57:28 AM         
   


> >
> >
> > How about:
> >
> >  SELECT * FROM qual WHERE (qual1+qual2+qual3) LIKE '%'+lcText+'%'
> > 

> > :-)
> > -----------------
> > Borislav Borissov
> >
> > Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> > The only thing normal about database guys is their tables.
>
>
> how do you ensure that the search result returns the appropriate result irrespective of the case
>
> i.e. "Hnd' & 'HND'
> I.E. 'BSc' & 'BSC'
>
> Thanks


Use UPPER() or LOWER() at both parts:
UPPER(qual1+qual2+qual3) LIKE '%'+UPPER(lcText)+'%'

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 7:34:40 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by surinder singh @ 8/14/2008 7:47:33 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 8:12:29 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by surinder singh @ 8/14/2008 8:34:19 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 8:17:10 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 8:48:23 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 8:57:28 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 9:22:01 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 9:35:09 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/16/2008 2:37:29 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Stefan Wuebbe @ 8/16/2008 8:55:49 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Jim Booth @ 8/16/2008 7:09:36 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Anders Altberg @ 8/16/2008 6:20:38 PM