Sql Wildcard

[cnicolapc]

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

 

[cnicolapc]

hi,
I may have solved

VarName= "%" & testocerca.Text & "%"

VarName= "Sus" or "usan" return "Susan"

Thanks anyway
Nicola