Hello Dr. Hipp,
Hello SQLite users,
CREATE TABLE test1(a VARCHAR(100));
INSERT INTO test1 VALUES('501');
INSERT INTO test1 VALUES(' 502 ');
SELECT * FROM test1 WHERE a=501;
SELECT * FROM test1 WHERE a=502;
SELECT * FROM test1 WHERE a<'502';
in MS SQL Server yelds the following results:
a
----
501
a
----
502
a
----
501
502
(please observe spacing from ' 502 ', meaning that it's treated on output as a
string (field's datatype from CREATE TABLE statement))
and the following:
CREATE TABLE test2(b INTEGER);
INSERT INTO test2 VALUES(503);
INSERT INTO test2 VALUES(504);
SELECT * FROM test2 WHERE b='503';
SELECT * FROM test2 WHERE b>'503';
produces:
b
----
503
b
----
504
Best regards,
George Ionescu
