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