Criteria to search for a text string

Started by Andrew Carrick, February 25, 2011, 10:28:52 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Andrew Carrick

I want to search all Customer names for those with "Trust" in them, can somebody remind me what the Extra Criterion is for a string search? TIA
Jelf Insurance Partnership
Hull, East Yorkshire, UK
Me and TAM used to have a thing but we've split amicably. She got the kids, I got the Camaro and the maid.

Hans Manhave

#1
ATC("Trust",ins.name)>0

This is a FoxPro reporting function.  More FoxPro functions can be found from here:

http://msdn.microsoft.com/en-US/library/h0zw37w7(v=VS.80).aspx

Logic being that if it returns non-zero, it exists.  Doesn't matter where it exists.  Similar to the FIND() function in Excel.
Fantasy is more important than knowledge, because knowledge has its boundaries - Albert Einstein

Andrew Carrick

Jelf Insurance Partnership
Hull, East Yorkshire, UK
Me and TAM used to have a thing but we've split amicably. She got the kids, I got the Camaro and the maid.

Ian Blundell

Ian Blundell
BHB Insurance
35 users, TAM 10.7, Fax@vantage 7.2

Andrew Carrick

Jelf Insurance Partnership
Hull, East Yorkshire, UK
Me and TAM used to have a thing but we've split amicably. She got the kids, I got the Camaro and the maid.