G Gkirkup Registered User. Local time Today, 07:45 Joined Mar 6, 2007 Messages 628 May 22, 2015 #1 How do I design a query to return a result in a wildcard format? So that I could enter a part of a name, and it returns all the names that include that part of name? Robert
How do I design a query to return a result in a wildcard format? So that I could enter a part of a name, and it returns all the names that include that part of name? Robert
C CJ_London Super Moderator Staff member Local time Today, 15:45 Joined Feb 19, 2013 Messages 17,620 May 22, 2015 #2 surround the wildcard with square brackets e.g. myfield like "* [*]*" will return any records where myfield has a * in it myfield = "xyz [*]" will return any record record where myfield=xyz*
surround the wildcard with square brackets e.g. myfield like "* [*]*" will return any records where myfield has a * in it myfield = "xyz [*]" will return any record record where myfield=xyz*
