>You're right Jim, maybe I was confuse too.
>See the 2 or 3 first digits are the one I'm interest on but I don't see a way to retrieve only those in a field of 7 digits when in reality I need to say '=' cause I don't want anything else.
>I think I will need another field in the table.
>So I think I gonna go that route
Edgar,
No you don't need another field, hjust SET ANSI OFF and SET EXACT OFF and then;
SELECT Whatever FROM Whatever WHERE Field = "01"
will find all records where the field BEGINS with "01"