On Wed, Jul 13, 2011 at 8:13 AM, Amit Chaudhuri
<[email protected]>wrote:

> Hi all,
>
> I have situation where a column may contain prices (REAL) or a string
> meaning "no price for this, sorry." I can handle this in application code
> but was wondering if I am overlooking a Sqlite feature which might do the
> same out of the box: perhaps a TYPE( ) or an IsText( ) function..?
>

The typeof() function.  http://www.sqlite.org/lang_corefunc.html#typeof


>
> A
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to