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?

Timothy D. Yeaney
MCSD, Charter Member
President, PAFOX (Potomac Area Fox User Group)
mailto:tim@eagleeyeinc.com
Vice President
Eagle Eye Publishers, Inc
Broaden Your Vision, Sharpen Your Focus