Filter on three question marks

Does anyone know how to set a filter on the actual value of three question marks in a text field? I only want to filter on the field “On hold” in the purchase inv.header" table where the field "On hold contains the value “???”

Edited by - PaulBradbury on 1/2/01 4:49:20 PM

Sorry, I mean’t to say enter the filter ???..??? (ie. from ??? to ???) This should work.

Thanks, it worked!

As replied on also, tell Navision you don’t want the question mark as wildcard, but as literal value. The difference is: Filter value: ??? means any three characters Filter value: =??? means three question marks John