SQL question

Florian Bogeschdorfer fb at memedia.de
Thu Nov 11 20:09:12 CST 2004


Ruslan, I tried a lot again...

I think that RegEx search (LIKE) does not work for fields kTypeDate?

See:
y=valselectreturncursor("SELECT geburtsdatum FROM KUNDENTable WHERE
geburtsdatum = '12.07.1970'")

put valcursorreccount(y)
-- 2

y=valselectreturncursor("SELECT geburtsdatum FROM KUNDENTable WHERE
geburtsdatum LIKE '12.07.1970'")

put valcursorreccount(y)
-- 0


?

Best regards, Florian



More information about the Valentina mailing list