>Yep... i remembered later how to do this. What you are actually doing is redefining the view that is in the .DBC depending on how you want it... So, you set the lcWhere to what you want, then run the create sql view command. Of course, this will requre each user to have there own .DBC, but that is not a big deal any way.
>
>Another idea is one I have used also... take the SQL from the view and build the where in code... then use SPT to do the view.
>
>One thing I din't know if you knew. If you create a parameterized view, and use like you can just populate the view with a % to get all records...
>
>select * from p1 where p1_function LIKE ?vp_function
>
>Then, you just populate vp_function with your value for that specific record, or % for all records.
>
>BOb

Thank you, thank you, thank you!! It was the LIKE % that did the trick! That's exactly what I needed. Thanks Bob!