Contains and Select

[Tenente_Ramon]

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.

[Suvrutt_Gurjar · Accepted solution]

Tenente_Ramon:

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

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

[Tenente_Ramon]

Thanks for your help. It works perfectly.

Thanks a lot!