Gossamer Forum
Home : General : Databases and SQL :

Different fields, Same criteria

Quote Reply
Different fields, Same criteria
If I have 5 fields I'd like to search with the same criteria, is there any shorter way of doing that instead of

"Field1='a' OR Field2='a' OR Field3='a'....Fieldn='a'"

Additionally, I would like to have multiple criteria

"(Field1='a' OR Field2='a' OR Field3='a'....Fieldn='a') OR (Field1='b' OR Field2='b' OR Field3='b'...Fieldn='b')"

Thanks a lot, I'm hitting 64k limits like there's no tomorrow here! :)
Subject Author Views Date
Thread Different fields, Same criteria Wiggy 9120 Nov 5, 2002, 1:06 PM
Thread Re: [Wiggy] Different fields, Same criteria
cornball 8662 Nov 5, 2002, 7:04 PM
Post Re: [cornball] Different fields, Same criteria
fuzzy logic 8625 Nov 6, 2002, 6:51 PM
Post Re: [Wiggy] Different fields, Same criteria
Andy 8692 Nov 6, 2002, 4:43 AM
Post Re: [Wiggy] Different fields, Same criteria
cornball 8600 Nov 8, 2002, 9:14 AM