Hello everyone and thanks much for your past help.<BR><BR>Silly question -- anybody know a good way to write some SQL code to query for the first three numbers of a zip code column in a table, but actually return all five numbers.<BR><BR>In other words, something like SELECT * FROM Members WHERE Zip = '376'. The full zip could be 37605 or 37659, etc., and I would like to have the full zip returned in the query, but I would like to have returned all zip codes in the table that contain 376 at the beginning of the zip. I had thought about using INST but discovered there is no INST in T-SQL.<BR><BR>Still kinda new to T-SQL. Would appreciate any pointers you may have. Thanks.