Mark,
You want to use the LIKE operator:
SELECT * FROM customer WHERE name LIKE ?cName
When you assign a value for cName, append a % to the value
cName = ALLTRIM(cName) + '%'
SQL Server will match everything that begins with whatever has been specified in cName.
-Mike