Criteria to search for a text string

[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

[Hans Manhave]

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.

[Andrew Carrick]

Thanks Hans.

[Ian Blundell]

You can also use
"Trust"$Ins.name

[Andrew Carrick]

Thanks Ian.