Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL question
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL question
Miscellaneous
Thread ID:
00895936
Message ID:
00895936
Views:
59
Hi,
I have a table like this but the number of name_x fields is variable, from 1 - 253. There
can be any number of dates. And entry of t coressponding to a certain date means that name_x
was present on that date.

dates name_1 name_2 name_3 ........ name_x
d_41201 t f t ........ t
d_41203 f t f ........ f
etc.

Is there a way to use an SQL statement to pull out only those names that were present on a
certain date, even though the number of name_x fields will vary?

Thanks
Steve Elster
Next
Reply
Map
View

Click here to load this message in the networking platform