>>>>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 :(.
>
>whatabout -- where cField = padr(?vp_custcd,5," ")

;). I tried that one too. Oracle gives me an error in that case, "Unknown SQL column."