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