>>>Version 7 is a great upgrade. There are a lot of new features that will really come in handy over time, especially Intellisense, which will immediately boost your productivity (after you stop typing SET STEP ON ON - lol - beta users will know what I mean there).
>>
>>LOL.. There are several like that (SET ORDER TO TO, etc). I agree that this is a MUST have upgrade. IMO, there is no reason to wait for SP1.
>
>OPEN DATABASE DATABASE
Now for the disappearing act:
SELECT * FROM < sometable > WHERE < somefield > IN (SELECT
At that time the Intellisense will do its David Copperfield act....
Regards,
Frank Camp