How to create a does not equal search string?

[#1]

Hi,

There is probably something small I am missing, but I can't seem to figure it out with my limited knowledge of the product.  I am trying to create a simple button that will pull values that do not equal 1349.  It makes me think that <> isn't correct to use for does not equal, but I am not sure what should be used instead.

[sunny_talwar]

May be do it in two actions

1) Select in Field

Field -> ResultTech

Search String -> 1349

2) Select Excluded

Field -> ResultTech

[sunny_talwar]

Another option is to do like this

Select in Field

Field -> ResultTech

SearchString -> ='(' & Concat(DISTINCT {<ResultTech -= {1349}>} Chr(34) & ResultTech & Chr(34), '|') & ')'

[swuehl · Accepted solution]

Have you tried as search string

<1349>1349

or

='<1349>1349'

?

[#5]

Thank you very much, appreciate the help.

[MarcoWedel]

maybe also possible:

='=ResultTech<>1349'

regards

Marco

[MarcoWedel]

another one:

(*^1349)

thanks to Stefan for his very nice post

Compound Search - demystified

Marco