Anybody know any gotcha's with LIKE? Our fund codes are in the form: '123-4567'. I am using SELECT against Fox tables.

This evaluates .T. against records in the table in the watch window as expected:
LIKE('4??-8002', ALLT(PyrlDist.Fund))

but does not work within a SELECT:
SELECT SUM(IIF(LIKE('4??-8002', ALLT(PyrlDist.Fund)), 1, 0)) AS ...

But this SELECTs data correctly:
SELECT SUM(IIF(LIKE('4*-8002', ALLT(PyrlDist.Fund)), 1, 0)) AS ...

So I can get my data, but I'd like to know why the ??'s didn't work. Any ideas?