String manipulation with wildcards

[DebbieCoates]

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

 

[Nimroduk]

The wildcard character's depend upon the DBMS you're connecting to. If you're using Access I believe the character you're after is %:

Select * from V_SOAPostCodeSearch where PCID Like 's183d%'

 

[DebbieCoates]

I am in vb, but connecting upto sql

 

[DebbieCoates]

brilliant, after hours of messing about, i swopped the * for % and it works great, many thanks

 

[JerryKlmns]

And since you found the wildcharacter for * it might save you time in future to know that the equivalant of DAO one character ? is ADO's _