Paul

I don't think your assertion is true.

It would be helpful to see your offending code. One thing - is the ACNO field always 4 chars, or more? Have you tried ALLTRIM(), as in "ALLTRIM( ACCNO) = ALLTRIM( lcYourParam)

Terry

>Hello,
>
>I am a Foxpro 6 beginner, and I have written a Foxpro report based on a parameterized view. This view compares the alphanumeric parameter to an alphanumeric field ACNO in its base table to select its records.
>
>My problem is that the parameter the report passes to the view can be either in the form of a word (as in "PAUL") or a number (as in "5515"). I have both these examples stored in the field ACNO.
>
>I find that the report will show beautifully when "PAUL" is used as the parameter, but flashes on and off (because the report is empty) when the parameter is "5515". For some reason the view does not like to compare alphanumeric fields to a parameter where the parameter is a number (as far as I can see). I can find no other reason for this event.
>
>How do I get round this?
>
>Thanks,
>Trimtro