Can't think of anything else. Are other views working? Maybe you need an updated ODBC driver.

>>Todd,
>>
>>Is ptrx exactly the same as chart_number? That is, is it padded with exactly the same number of blanks? You could try trimming ptrx then using LIKE instead of = with a wild card, like this:
>
>Is exactly the same. Even did it without the parameter, stored the chart_number to ptrx and redid with the parameter and still no records pulled.
>
>The % also didn't work. Gave me an invalid arguement error. Anymore ideas?
>
>>

>>ptrx=TRIM(ptrx)+'%'
>>SELECT * FROM mwpat WHERE mwpat.chart_number LIKE ?ptrx

The % is a SQL wildcard (like * in MSDOS). It works with LIKE, but not =.