> 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 Arnon