[sqlite] Join two select field together

[[EMAIL PROTECTED]]

Hi All,

I wonder does Sqlite have feature such as join two string fields together.
e.g: Select FirstName + LastName From Username

Thank you,

Ming