>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.
If it has variable length fields, it must keep their lengths somewhere, therefore I think it may have a function to retrieve that length. So,
...vp_custcd = "U6" and len(vp_custcd=2)
or something along that line. Of course, the len() may be called SizeOF(), ShoeSize() or whatever in Michael's server's dialect of SQL.