Hello, In mysql: mysql> SELECT * FROM test1 WHERE a=501; +------+ | a | +------+ | 501 | +------+ 1 row in set (0.02 sec)
mysql> SELECT * FROM test1 WHERE a=502; +-------+ | a | +-------+ | 502 | +-------+ 1 row in set (0.00 sec) mysql> SELECT * FROM test1 WHERE a<'502'; +-------+ | a | +-------+ | 501 | | 502 | +-------+ 2 rows in set (0.00 sec) and for the second table: mysql> SELECT * FROM test2 WHERE b='503'; +------+ | b | +------+ | 503 | +------+ 1 row in set (0.09 sec) mysql> SELECT * FROM test2 WHERE b>'503'; +------+ | b | +------+ | 504 | +------+ 1 row in set (0.00 sec) Regards, ----- Original Message ----- From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 1:42 AM Subject: Re: [sqlite] Re: SQLite version 3 design question: '500'=500? Who can tell me what other SQL database engines do with the following? 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'; Or how about this: 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'; -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]