Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wild card in where clause
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Wild card in where clause
Miscellaneous
Thread ID:
00246921
Message ID:
00246921
Views:
51
Can you use a wildcard in the where clause of a select statement?
if thisform.cToShow = "All"
    lcCatToShow = ""        &&>>> This is where I want a wildcard
   else
    lcCatToShow = thisform.cToShow  && Or a specific one
endif

SELECT a.company, a.conname, a.ab_id ;
	from AddressBook a;
	inner join CatLink on a.ab_id == CatLink.ab_id ;

	where obsolete = .f. ;
	and CatLink.Catagory == lcCatToShow ;

	ORDER by &lcDisplayOrder  ;
	into cursor DisplayNames
I tried the "" and got nothing.

TIA
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!
Next
Reply
Map
View

Click here to load this message in the networking platform