finding field contains

[bspoll]

is there a way to do a find field contains?

Example:

I want to do find all records that the part number contains "573" and the found set will show:

12573

343573

88757355

[Ocean West]

Try this...

Part_Number: Part Number

gField: A global you are searching for

cField: Calculation to find Result.

code:

---

PatternCount(Part_Number, gField)

---

then perform search on cField for anything >0

[This message has been edited by Ocean West (edited February 19, 2001).]

[bspoll]

This does not seem to work, does it matter if product number contains both numbers and letters (sk45170), would like to be able to search 45170 and get sk45170 and sk45170-2 etc....

[john.daly]

Make sure all your fields are text fields and not numbers.

[bspoll]

all fields are text except for pricing and a picture container. can search sk45170 but not all of my customers relize that they need the sk first, also not all part numbers have "sk" there is also other vendor codes in front of number.

[BobWeaver]

cField should be number, not text.

[john.daly]

Yes, I agree that cfield ought to be Number (although it works if it is text!). I set up the solutin as described using the data given and it certainly worked for me. Are you still having problems with it?

[bspoll]

Thanks Guys, sorrythis took so long-I got stuck doing another project.