SQL Database Integrationhttps://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Search on Partical Valuehttps://www.infopathdev.com:443/forums/thread/17100.aspxMon, 12 Dec 2005 20:11:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17100bslaght0https://www.infopathdev.com:443/forums/thread/17100.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17100Thanks I was able to make it work from this.Re: Search on Partical Valuehttps://www.infopathdev.com:443/forums/thread/17099.aspxFri, 09 Dec 2005 20:30:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17099Matt Faus0https://www.infopathdev.com:443/forums/thread/17099.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17099Try this:<br /><br />SELECT * FROM customers WHERE CONTAINS(firstName, ' "D*" ')<br /><br />---------------<br />Matt Faus<br />Search on Partical Valuehttps://www.infopathdev.com:443/forums/thread/16761.aspxFri, 09 Dec 2005 19:48:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16761bslaght0https://www.infopathdev.com:443/forums/thread/16761.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16761I want to query with a partial name on the database,<br />I want to search for all of the first names that start with D, seems like unless I put in a match the query won't return results.