>> Using a CREATE SQL VIEW to create a parametereized view, I've found that
>> WHERE conditions get rearranged and are no longer correct...here is what I
>> wanted...
>
>if anything it is another reason not to use the View designer - not views
>the view designer has several limitations - probably just another one of them
>I usually use the designer for simple views/queries or the skeleton for more complex ones


Arnie

Where are you putting your Views these days?

Tom (Chauffeur for Minnesota Drunks)