Hi,<BR><BR>I have some part numbers where the 4 digit prefix is all that I need to identify a part(e.g. 2AG2). However, everyone enters the 8 digit part number into the database (e.g. 2AG2-9001).<BR><BR>There are several 8 digit part numbers for the same part (e.g. 2AG2-5000, 2AG2-0003 etc.) I need to be able to query the database just using the first four digits of the part number. <BR> <BR>People would like to enter either the 8 or just the 4 digit part number. Any ideas???