>Darn notebooks. I hit the wrong button. anyway i would like to test in the WHERE statement if the year in track.schoolyear is = to the value in schoolyear.nschoolyear. So this year it would be equivalent to
>WHERE track.schoolyear = 2003.
>So to summarize
>I would like to be able to change the value in the WHERE statement for the schoolyear.
>
You can't build a parameterized view like you can in VFP, but you can query it just like any other table. Build the view without the where clause, and supply that when you need it.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.