如何在SQLIte中获取子字符串?

I retrieve quite a lot of data from SQLite database. When retrieving I map it to different views in my application. There is a text field in my table from which I don't want to get the full text, just first n chars. So if my query for example is:I retrieve quite a lot of data from SQLite data