[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 122
  • Last Modified:

How to match records stored within an array?

I have an array variable with undeclared number of elements.  I read values from a database into the array, can be any number of elements.

I now loop through the database looking for a match on these elements.  The problem is that from a known total population of possible values, any record can have any number of the elements, in any order.

How do I do the comparison?

1 Solution
you can make a array string

(13,24,25,87) and make a query

Select * from Whatever where YourValue In(13,24,25,87)

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now