[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Find records that has all items in the list

  • Thread starter Thread starter jonathan.wilson
  • Start date Start date
Status
Not open for further replies.
J

jonathan.wilson

Guest
Now this post won't be helpful answer... my DBA hat on, the data structure is wrong here. You shouldn't have a comma separated list of entities in a field as it's not good "normal form". You want something that's elegant to solve a problem; but it's your data structure that's the real issue. If you always place entries in an order on the string and don't just add randomly to the end you should try MATCHES based off that sort order "*A*B*" but this is slow.

Continue reading...
 
Status
Not open for further replies.
Back
Top