SQL Filter Expression for empty array

3 posts / 0 new
Last post
Offline
Last seen: 1 year 1 month ago
Joined: 02/22/2021
Posts: 6
SQL Filter Expression for empty array

Hi,

Like to check if there is a SQL expression to check if the string sequence/array is empty? I need to do content filtering such that if either a particular string exists in the sequence/array or if the sequence/array is empty, I should allow the data to go through. Thank you.

Howard's picture
Offline
Last seen: 14 hours 14 min ago
Joined: 11/29/2012
Posts: 573

Sorry to say, there is no way to test for the length of a sequence in the SQL filter expression.  I suggest that you use a dummy string so that the sequence is never really empty.  So, you can test for the presence of the particular string or the dummy string to pass the filter.

Offline
Last seen: 1 year 1 month ago
Joined: 02/22/2021
Posts: 6

Ok, thanks, would use that method for now.