Without seeing and playing with the data, it's not easy to find out. However, I can suggest 2 things to review >
1- You might miss some brackets here [ParcelNumber.Number]
2- We might have some problem to deal with the "like" operator.
Did you review the help documentation related to this ? There is not much information, but it might help.
Please, consider to have a dataset to share. It would allow us to further investigate.