How to use SQL „LIKE“ on a GlobalStream where the Attribute Datatype is a LONGVARCHAR
i‘m traying to run a sql LIKE Query on an attribute datatype LONGVARCHAR.
I also try allready with the SUBSTRING(Attribute,1,...), when i run the query, the resultat is empty without errors.
select text from table
where text like ‘%abc%‘
many thx for help