query to filter on records containing ???

[DaveT99]

is it possible to create a query that will return all records that contain a number of ???? within a description fields

[CJ_London]

easy answer is to use the instr function

where instr(descfield,"?")>0

?instr("abc?123","?")
4



or the like operator

where descfield like "*?*"

?"abc?123" like "*?*"
True





but I suspect the issue is non recognised characters being displayed as '?'

[jojowhite]

you may also try:

SELECT * FROM YourTableName WHERE FieldName LIKE "*????*"

[DaveT99]

Many thanks CJ_London, didnt expect to get a reply so quick, will try that now