Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 'in' option
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL 'in' option
Miscellaneous
Thread ID:
00381527
Message ID:
00381544
Views:
14
>Can the IN option use numeric values? Example:
>
>SELECT name FROM people WHERE age IN (32,56,23)
>
>I get no records returned.

Try:

where inlist(age,32,56,23)
Rip Ryness
International Falls, MN
Previous
Reply
Map
View

Click here to load this message in the networking platform