Michael,
Your field may be a variable length field meaning that the entire contents of the field is "U6". This isn't possible with FoxPro, but it is with other databases. Trimming your parameters as you're doing now is probably the best approach.
>>>>>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."