How about rewriting a tiny portion of it:

left(zip,5) in ('22046','22048','22049','22030')

This appears to work.

>I've search the docs and can't find what I'm looking for. Perhaps someone here has a quick solution.
>
>I'm trying to access SQL Server 7.0 and am spoiled by VFP SQL syntax. How do I convert the following to something that works in SQL 7.0?
>
>

>Select city,state,zip from table1 where zip in ('22046','22048','22049','22030')
>

>
>Fox will return 9 digit zip codes, but SQL 7.0 returns only 5 digit zip codes.
>
>I know that
>
>

> .. where zip like '22046%'
>

>
>will work in SQL 7.0, but I'm looking for a solution where I don't have to rewrite the syntax I'm currently useing i.e. "IN ()"
>
>Anybody know SQL Server 7.0 and have a better solution?

Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao