How to searching text stream columns in SQL
I have a table with a Varchar(max) column that I have created via the HealthShare SQL portal, and I see that in it's underlying class that column corresponds to a
When I try to do a text search on that column (referenced as cd.Code in the example below) I get an error
select *
from DevTools_CodeAnalysis_tables.Code cd
inner join DevTools_CodeAnalysis_tables.MethodData mtd
on charindex( mtd.qualifiedRef, cd.Code) > 0
It produces the error
Scalar function CHARINDEX (arg2) not supported for stream fields
How do I search it?
Product version: IRIS 2021.2
$ZV: IRIS for Windows (x86-64) 2021.2.1 (Build 654U) Fri Mar 18 2022 06:09:35 EDT