|
mortie Wanderer
Joined: 26 Sep 2002 Posts: 73 Location: United Kingdom
|
Posted: Tue Jun 08, 2004 12:19 pm
%query in a non case sensitive search |
Hi,
I use this line to search my db
DBQuery=%query( %pos( "%-1", &Name|ro))
At the moment when i give a keyword(s) to search it only picks up on the case sensitive ones in the db.
e.g
Intersection
(misses out any records that the keyword is "intersection")
Ive tried searching on the forums but couldn't find an answer.
Is there a way to force %query to look al all occurances regardless of case?
Thanks
mortie |
|
|
|
LightBulb MASTER
Joined: 28 Nov 2000 Posts: 4817 Location: USA
|
Posted: Tue Jun 08, 2004 5:45 pm |
Define the case.
DBQuery=%query( %pos( %lower("%-1"), %lower(&Name|ro))) |
|
|
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|