Retrieving value by like query from ms access database

Retrieving value by like query from ms access database

In the below code I have not got an error, but wanted districtname and
officename to retrieve first 6 characters from the database
So if district name is Lucknow City it only takes out Luckno
strSQL = "Select pincode from pincodes WHERE Districtname = '" & city & "'
AND officename = '" & area &"';