>Can vfp allow me to give my users the capability to enter in wildcard characters in a text box and perform searches? ie enter in patient number 123???should generate all patient numbers that begin with 123...

You can try using the SQL LIKE command with the wild cards for "_" representing a single character position and "%" representing more than one.

SELECT * FROM patients WHERE patientnum LIKE "123%" could work.