Like statement error on a SQL DB using vb.net

[dzisaacs]

UpdateDataGrid("SELECT DISTINCT Person.F_Name, Family.L_Name, Family.Address " & _
"FROM Person, Family, Pos_Person_Int " & _
"WHERE Person.Fam_ID = Family.Family_ID And Pos_Person_Int.CH_Pos_ID = 3 " & _
"And Pos_Person_Int.Person_ID=Person.Person_ID And Family.Address Like ''" & address & "%")

I've been struggling with this statement..I've searched for the like statement but didn't find anything helpful..I would thank in advance if someone knows how to use like in a query of this type.

 

[chrissie1]

it seems ok to mee. but i dont know what its suppossed to do and what the result is suppossed to be

family.adress like 'name%'

gives you everything beginngin with name

family.adress like '%name'

will give you everthing ending on name

family.adress like '%name%'

will give you evrything that has name in it



Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[bduke]

Try
address = "' & address & '" "'%'"")