DebbieCoates
Programmer
can anyone spot what I am doing wrong here, i think it is becasue of the quotes I am using, but cant work out how to put them
I am using this
sSQL = "Select * from V_SOAPostCodeSearch where PCID Like '" & sPostcode & "*'"
which gives me this
Select * from V_SOAPostCodeSearch where PCID Like 's183d*'
I am trying to find everything in the V_SOAPostCodeSearch table which has a PCID starting with s183d
i dont think the wildcard is working
would appreciate any help
I am using this
sSQL = "Select * from V_SOAPostCodeSearch where PCID Like '" & sPostcode & "*'"
which gives me this
Select * from V_SOAPostCodeSearch where PCID Like 's183d*'
I am trying to find everything in the V_SOAPostCodeSearch table which has a PCID starting with s183d
i dont think the wildcard is working
would appreciate any help