Android Question SOLVED: SQLite concatenation

[peacemaker]

HI, All

android.database.sqlite.SQLiteException: near "||": syntax error (code 1): , while compiling: SELECT FName || ' ' || Name || ' ' || SName ', ' || Position FROM CompanyWorkers WHERE UserID = 'F185C519D5E91F03'

Requested like
SQL.ExecQuerySingleResult(req)

Why error?

SOLVED:

$"SELECT IfNULL(FName,'') || " " || IfNULL(Name,'') || " " || IfNULL(SName,'') || ", " || IfNULL(Position,'') FROM CompanyWorkers WHERE UserID = '"$ & UserID & "'"