NEED A SYNTAX FOR A SQL ON ALPHA FIELD
Posted on 2007-12-02
I have table wich contains a key wich is alpha/nummeric, table will have value from " 1600" untill " 1900"
field is 12 digits and right aligned with leading spaces
when i call:
SELECT * FROM CREDOPEN where key3 like '%1673%' I get a perfect list from all record wich has " 1673"
but I can't figure out how to get all from 1673 untill e.g. 1840
if I call
SELECT * FROM CREDOPEN where key3 >='1673' and key3 =< '1840' I get nothing
what do I wrong in syntax for this kind off search
(p.s. I have pervasive on windows-xp as record manager /odbc)