>I am creating a parameterized view. One of the parameters in this view is 'dbfname LIKE ?vp_dbfname. I thought this would allow me to have something similar to the 'contained in' operator ($). So, for example, if vp_dbfname = "A" then all dbfname's with 'A' in them would be pulled. The problem I am having is that no data is being pulled. The If I just use = instead of LIKE it works fine. I'm probably missing something.
The idea of 'LIKE'is to use wildcards (percent sign and underscore). E.g. if you want to retrieve all records started with "A", then vp_dbfname="A%". For records containing "A", you use construction vp_dbfname="%A%", etc.
Edward Pikman
Independent Consultant