Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting fields based on another field in the same reco
Message
From
10/09/2004 13:45:07
 
 
To
10/09/2004 13:41:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00941126
Message ID:
00941127
Views:
14

Hello,
I have a table like following:

CODE|IDUSE |
---------------
A |FAXA |
V |FAXB |
A |FAXC |
---------------

What I want is to run a select statement on this table that finds when the IDUSE matches FAX(which I will be supplying through code)+CODE (so the only one that would correctly show is FAXA). Sorry if I didn't explain this very well... but any help would be greatly appreciated. Thanks!!

MAC
SELECT ... EVAL(IDUSE) AS FAX ...
Previous
Reply
Map
View

Click here to load this message in the networking platform