Thanks for the input. The database is actually SQL 2000 sp3. I resolved the issue by changing the LocationID=null to LocationID=0 in the view. I'm not entirely...