C cnicolapc Active Member Licensed User Longtime User Feb 28, 2011 #1 Hi, In a SELECT ......WHERE.....statement you can use the wildcard. Example to return all Record as names Susan whith "Sus" or "usan".? You can set a variable with name such as "*" & Name & "*" ? Thank You Nicola
Hi, In a SELECT ......WHERE.....statement you can use the wildcard. Example to return all Record as names Susan whith "Sus" or "usan".? You can set a variable with name such as "*" & Name & "*" ? Thank You Nicola
C cnicolapc Active Member Licensed User Longtime User Feb 28, 2011 #2 hi, I may have solved VarName= "%" & testocerca.Text & "%" VarName= "Sus" or "usan" return "Susan" Thanks anyway Nicola Upvote 0
hi, I may have solved VarName= "%" & testocerca.Text & "%" VarName= "Sus" or "usan" return "Susan" Thanks anyway Nicola