Searching for two charcters only 1

[balllian]

is there a way in access to look for characters which are two or less in length.

The problem is that the postcode field in some instances has become truncated and only appears as 'LL' and not 'LL3'. Is there a way of picking up a string which is only two characters in length.

Thanks in advance. Im struggling with this must be a friday afternoon thing.

Thanks for any help you can provide me with this.

 

[lupins46]

Create a query on your table.
For the postcode field set the criteria to:
Like "??