>>>I have a remote view to an oracle table. The view has a view parameter on a character field. If I run the sql from the view designer and enter "U6 " as the view parameter one record is returned. "Great. It works," I think. I close the view designer and open the view up from the command windows. I assign vp_custcd = "U6 " (the exact same value in the view designer) and requery. Zero records returned. Huh? If I change the view parameter to "U6" it returns the correct single record. I've tried turning exact off with no difference. Is there something I am missing here?
>>
>>Argh! In my browser is shows the all the "U6" values with no spaces after the 6. The first two times I requeried I used the value "U6---" where "---" are spaces. The last time I used "U6" and it worked.
>
>Not sure if you were answering your own question, but "... where cField like ?vp_custcd" could work if you passed the value 'U6%'

That will not work because this will also pull up U65, U658, U657383, etc. Actually, I ended up having to alltrim all my views before requerying. I don't like making work-around solutions, however :(.