Hi all, I have a problem and I'm not really sure if I can solve it with SQL/SAPDB:
I have a field HAYSTACK (varchar) in my table and a query that returns n NEEDLES (integer). Is it possible to check if one of the NEEDLE-Values is in the HAYSTACK-String? Example: Haystack: '1;2;3;4;5;' Needle-Resultset: 2 / 4 / 7 => tricky function that returns TRUE 'cause a needle-value is in Haystack Do anyone of you know a way to achieve this? (using a asociative table for haystack could solve this, but is this really neccesary? it seems to me a little bit oversized...) Thanks in advance S. Lorenz -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
