codice:
SELECT * FROM tabella
WHERE campo LIKE 'C%'