How do I check a part of a record for a string?

[Glenn]

For example, if someone does a search for "abcde" and I want to find every record that has "abcde" anywhere in it, how to I find that record?

 

[computerGeek]

Create a conditional statement using substring()? Not sure.