SQL Query question

[RudyL]

Can anyone tell me why this sql string gives me an error?

"SELECT * FROM WorkOrders WHERE CustomerRefNumber = 'MM-0000001' AND JobCompleted = '1'"

I am using a MSA 2000 db and ADO.

I get an error of "Data type mismatch"

Thanks,
Rudy -