Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wild card in where clause
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00246921
Message ID:
00246930
Views:
17
Cool, I'll check it out. Thanks for the help.

>You can use LIKE, instead of =. That will allow you to use % and _ as wild cards (like * and ? in DOS respectively). For example:
>
>SELECT * ;
>  FROM mytable ;
>  WHERE MyField LIKE '%'
This will give you everything.
>
>>Can you use a wildcard in the where clause of a select statement?
>>
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Reply
Map
View

Click here to load this message in the networking platform