Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
LIKE ('4*-8002') works, LIKE('4??-8002') doesn't
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement