>I'm using a database view. I want to set one of the filters to a variable. If I use the view designer it thinks the variable name is a character expression.

When designing the view, use the following example:
?m.myVal

Robert