Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL LIKE command
Message
From
17/08/1998 14:33:23
 
 
To
17/08/1998 14:00:47
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00127474
Message ID:
00127505
Views:
30
>>findtext = "%" + thisform.txtsearch.value + "%"
>>select * from task;
>>where description LIKE findtext

findtext = '%'+alltrim(findtext)+'%'
findtext = upper(findtext)
select * from task where upper(description) LIKE findtext

You also will want an index on UPPER(description)...

BOb
Previous
Reply
Map
View

Click here to load this message in the networking platform