A variable and wildcard search in one string

[tinkerz1]

Hi,

If I have records in a field and I want to find a string of text like xxxRedyyyOHLzzz

I have done it like this, but I know what to make OHL a variable

Sum({$<[ABC]={"*RED*OHL*"}>}Data)

But the variable is will come up as text, how can I can it to search on string with a fixed character and a variable

Sum({$<[ABC]={"*RED*$(vVariable)*"}>}Data)

Thanks,

Neil.

[pokassov]

Sum({$<[ABC]={"*RED*$(=vVariable)*"}>}Data)

[tinkerz1]

Hi,

Thanks but putting the variable $(=vVariable) inside the * * it ends up being a text string search.

I am having the same issue,

[jonathandienst]

Thanks but putting the variable $(=vVariable) inside the * * it ends up being a text string search.    

Is that not what you want?

[tinkerz1]

It means I am searching for a string called $(=vVariable) Not what the variable is named 'OHL'

Thanks