I’m new at this… I’m trying to search across three fields . The only way I’ve been able to do this is to input the value 3 times. I’d like to be able to search the three fields with one input… Is that possible
Here is what I’ve got…
SELECT “RosterInfo”.“Team”, “RosterInfo”.“Team2”, “RosterInfo”.“Team3”, “RosterInfo”.“RosterID”, “RosterInfo”.“Position”, “memberPersonalInfo”.“Phone_Number”, “memberPersonalInfo”.“First_Name”, “memberPersonalInfo”.“Last_Name”, “memberPersonalInfo”.“Notes”, “RosterInfo”.“Status” FROM “security”.“rosterinfo” AS “RosterInfo”, “security”.“memberpersonalinfo” AS “memberPersonalInfo” WHERE “RosterInfo”.“RosterID” = “memberPersonalInfo”.“RosterID” AND ( “RosterInfo”.“Team” = ? OR “RosterInfo”.“Team2” = ? OR “RosterInfo”.“Team3” = ? )
Thanks
Bob