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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao