how can I serach for ? (question mark) in a field data
J John W. Vinson Feb 7, 2008 #2 how can I serach for ? (question mark) in a field data Click to expand... Since ? is a wildcard matching any character, you must "insulate" it with brackets: LIKE "*[?]*" John W. Vinson [MVP]
how can I serach for ? (question mark) in a field data Click to expand... Since ? is a wildcard matching any character, you must "insulate" it with brackets: LIKE "*[?]*" John W. Vinson [MVP]
B box2003 Feb 8, 2008 #3 You could use the VB InStr function. InStr([start, ]string1, string2[, compare]) google instr for more info or msdn. John W. Vinson said: how can I serach for ? (question mark) in a field data Click to expand... Since ? is a wildcard matching any character, you must "insulate" it with brackets: LIKE "*[?]*" John W. Vinson [MVP] Click to expand...
You could use the VB InStr function. InStr([start, ]string1, string2[, compare]) google instr for more info or msdn. John W. Vinson said: how can I serach for ? (question mark) in a field data Click to expand... Since ? is a wildcard matching any character, you must "insulate" it with brackets: LIKE "*[?]*" John W. Vinson [MVP] Click to expand...