The only way to filter or use parameters on a view, is to use unconverted select fields.
For example; if you do the following in a view: ” Select CONVERT(char, dbo.tblStays.DateStart, 101) AS ‘Stay Start’, CONVERT(char, dbo.tblStays.DateStop, 101) AS ‘Stay Stop’ ” Then you can’t do “WHERE [Placement [...]