Where Clause on first 3 number

[bla1979]

I have a table of zip codes, I want to be able to search by only the first 3 numbers, but I want the user to input all 5. Anyone have a clue.

 

[DotNetGnat]

example:

Select * from mytable where Left(ZipCode,3)='152'

-DNG

 

[bborissov]

SELECT * 
   FROM ....
   ...
  WHERE ZipCodeField LIKE LEFT(UserInputCode,3)+'%'

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.