idkfa <[EMAIL PROTECTED]> wrote:
@SQLiteParameter = 'a','b','c'
WHERE SomeColumn IN (@SQLiteParameter)
Is there a way to accomplish this type of query?
WHERE @SQLiteParameter LIKE ('%''' || SomeColumn || '''%')
Not very fast though (in particular, it can't use an index on SomeColumn
if there is one).
In SQL Server I
remember writing a function that translated a list of strings to a
table in memory that would satisfy the IN clause.
You can do this in SQLite, too.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------