[sqlite] Re: SQLite version 3 design question: '500'=500?

[George Ionescu]

Hello Dr. Hipp,
Hello SQLite users,

in MS SQL Server, the following line

SELECT '500' = 500;

returns a column having the alias '500' and the value 500 :-o

However, wanting to test how the engine compares strings and numbers:

SELECT 'match' WHERE '500' = 500;

returns 'match'; also, the following statements return the same result:

SELECT 'match' WHERE '    500    ' = 500;
SELECT 'match' WHERE '500' = 499 + 1;

Hope I've been of some help.

Regards,
George Ionescu