How to compare to a text in a sql query

[Jean203]

Hello everyone,

I would like to make a SQL query to assign an image, according to my character level. In my app, I have a number variable “Character level” and I would like to compare this value in my SQL query.

The SQL is like that :

SELECT *, “image1.png” color FROM data WHERE “Required level” <= ‘"+document.childByName(“Character level”).content.doubleNumber+"’
UNION
SELECT *, “image2.png” color FROM data WHERE “Required level” > ‘"+document.childByName(“Character level”).content.doubleNumber+"’

But it does not work. Where is the error ?

Hope I explained correctly.

Thanks by advance.