Like "#" not working

Giganews Newsgroups
Subject: Like "#" not working
Posted by:  Ron Paii (ron81p…@gmail.com)
Date: Thu, 9 Jan 2020

Looks like Microsoft patching is breaking queries

Using Like "#" in query criteria no longer works

SELECT tblJobItem.*
FROM tblJobItem
WHERE tblJobItem.Item Like "[0-9][0-9][0-9][0-9]";

will find all items with a 4 digit value

SELECT tblJobItem.*
FROM tblJobItem
WHERE tblJobItem.Item Like "####";

finds nothing.

This work before Jan 9th 2020

Anyone know a fix?

Windows 7, 8.1 and 10

Access 10, 13, 16

..

Replies