Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the IN clause
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using the IN clause
Miscellaneous
Thread ID:
00576615
Message ID:
00576615
Views:
53
Can anybody lend a hand with this one.

I'm storing a comma delimited list of ID's in a field and I wanted to do a

select * from Contact where contact.ID in ?ListOfIDs

But because the ID is an integer and the list is a string it gives me an error "operator/operand type mismatch"

Any sujestions as to how I overcome this?
Caroline
Next
Reply
Map
View

Click here to load this message in the networking platform