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!