[sqlite] String.Substring Generates Error

[Etienne Charland]

How about this line of code

var Obj = context.MediaCategories.Select(c => "ABC".Substring(1) != 
null).ToList();

It produces

SELECT 
CASE WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NOT NULL) THEN 1 
WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NULL) THEN 0 END AS [C1]
FROM [MediaCategories] AS [Extent1]


-- Executing at 29/05/2015 9:17:06 PM -05:00

SQLite error (1): no such function: Substring
-- Failed in 89 ms with error: SQL logic error or missing database
no such function: Substring