Hello all
I have the following requirement:
Table a
--------
id int
expr text
result integer
Insert into a values (10,' > 2');
Table b
-------
id int
answer text
Insert into b values (10,'10');
I need to evaluate the condition that 10 > 2 and store the result of that
expression in a.result.
I am failing to have the expression evaluated.
select b.answer || a.expr from a inner join b on a.id = b.id; -- gives 10
2
I need to see 1 (since 10 > 2).
Kindly help!!
Best
--
Using Opera's mail client: http://www.opera.com/mail/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
