Hi Rex,
Then the issue is different because, that's the way debug window shows you string variables.
>You're correct except the remote view is creating the SQL and I'm not getting an error, just no matching data. In debug the value of vp_cChar4 is "MB" not 'MB'.
>I've tried LIKE but the % is unknown to me. Where does the % sign go?
vp_cChar4 = vp_cChar4 + "%"
SELECT * FROM YourTable WHERE Field LIKE ?vp_cChar4