Contains and Select

My App has 2 tables: MATERIAIS and CONJUNTOS.

I was trying to select a group of information from MATERIAIS to CONJUNTOS based on a condition, and I got it.

SELECT (MATERIAIS [ITEM], [_THISROW].[VTR/EQ] = [VTR/EQ])

Now, I’m trying to filter this data. I need to get only data that contains the fragment “©”, like “Bolsa de SAlt ©”.

I tried to use CONTAINS() like…

CONTAINS(SELECT (MATERIAIS [ITEM], [_THISROW].[VTR/EQ] = [VTR/EQ]),“©”)

…or…

SELECT (MATERIAIS [ITEM], And([_THISROW].[VTR/EQ] = [VTR/EQ], CONTAINS(MATERIAIS [ITEM], “©”)))

… but didn’t work. (the field just don’t appears on app)

I need some help.

Tks.

Please try
SELECT (MATERIAIS [ITEM], And([_THISROW].[VTR/EQ] = [VTR/EQ], CONTAINS([ITEM], “©”)))

3 Likes

Thanks for your help. It works perfectly. :raised_hands:t2:

Thanks a lot!

2 Likes