Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tricky Attempt
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00768370
Message ID:
00768375
Views:
19
Try something like:

SELECT * FROM PARTS WHERE ;
AT(":2:", parts.items) > 0 OR LEFT(parts.items, 3) = ":2:" OR ;
AT(":8:", parts.items) > 0 OR LEFT(parts.items, 3) = ":8:")

Regards
-Mark


>Hi All,
>
>I have a column in the table that looks like this
>
>Items
>-----
>1:2:4:7:9:12:
>3:4:6:8:10:11:13:
>2:4:8:9:12:14:
>6:9:13:17:22:
>
>I want to select all rows where Items contain 2: or 8:. I started with
>select * from parts where atc("2:",parts.Items)>0. This select statement only give me row 1,3,4 (row 4 because of 22:). How can I modified the select statement to include 8: using one select statement? Is this possible?
>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform