select based on characters within a string

[Guest.Visitor]

Dennis, I can't think of a better way. If those characters are supposed to mean something, then I might suggest setting a flag in another field to designate it's meaning rather than trying to put the intelligence in the field like it's being done. Bill Dennis Wapiennik wrote: > Is there a better way to select records that contain one or more > specific characters anywhere within multiple fields?

[Guest.Visitor]

this concatenates the three fields into one field and translates ; to *, so then you essentially just have to look for * in one field <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6ae56e9e/1')

[Guest.Visitor]

Is there a better way to select records that contain one or more specific characters anywhere within multiple fields? <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6ae56e9e')

[Guest.Visitor]

I'd venture to guess that your original query will be much faster.