Am using an access database. I have a database table (postcodes and areas) of post codes set out as eg. LS27 7 and when a user submits a form with the post code set out like LS27 7ah. I am wanting to basically query the database to query the database for the correct area so I can do my insert into another table. I already tried using the LIKE statement but this didnt work (as I suspected) any ideas ??