AT Search

[Jeff_Ward]

How can I search a memo field for a work using the "AT" command. It does not appear to work correctly____AT("Alcohol",events->narrative) ____Shows incorrect syntax

[kfleming]

At will only work with character fields.__To test whether a memo contains a particular string you can use the $ operator to test if the string is contained in the memo.__For example you might use:____IIF("Alcohol"$,events->narrative,"This record matches","This one does not match") ____The catch is that you can only do a true/false test on the value you are testing. You cannot return the partial contents of the memo depending on where in the memo the string is present.____Kathleen__R&R Support

[Jeff_Ward]

I tried that exact expression and it did not work. I get a syntax error. ____>At will only work with character fields. __>To test whether a memo contains a particular string you can __>use the $ operator to test if the string is contained in the __>memo. __>For example you might use: __>__>IIF("Alcohol"$,events->narrative,"This record matches","This __>one does not match") __>__>The catch is that you can only do a true/false test on the __>value you are testing. You cannot return the partial __>contents of the memo depending on where in the memo the __>string is present. __>__>Kathleen __>R&R Support __

[Rick_W_Johnson_(Guest)]

I think you need to remove the comma after the dollar sign in the IIF statement.