Like in Dlookup

[msp4422]

Hi




Could you tell me how we can achieve the below req:


SV="Russia"
DeptId = DLookup("city","Lok","country like 'SV'")


Thanks.

[pbaldy]

DeptId = DLookup("city","Lok","country like '" & SV & "'")

[msp4422]

Could you explain me the meaning of the '*" & .. How and where we need to use them.. thanks once again

[pbaldy]

* is a wildcard; you use it when you want inexact matches, like anything starting with P (P*) or anything with Paul in it (*Paul*).