How to use SQL „LIKE“ on a GlobalStream where the Attribute Datatype is a LONGVARCHAR

Question

darko susnjara · Feb 20, 2020

Hi all,

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.

The Query:

select text from table

where text like ‘%abc%‘

many thx for help

Darko