use "LIKE" instead of "=" in the WHERE clause of your SQL:

SELECT field FROM Table WHERE text LIKE "text*"