https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/21378.aspxMon, 02 Jul 2007 16:33:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21378Greg Collins0https://www.infopathdev.com:443/forums/thread/21378.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=21378The easiest way to do what you want is to set up another field which stores just that second character. You can set up a default value formula using substring() to pull out that second character. Then base your filter off this additional field.https://www.infopathdev.com:443/forums/thread/21331.aspxThu, 28 Jun 2007 13:45:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21331dlgross0https://www.infopathdev.com:443/forums/thread/21331.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=21331<p>Using IP 2003.</p><p>I have a Job Category dropdown with a value that is equal to a Letter, I have a another Job title dropdown in which I would like to apply a filter in which the 2nd letter of the Job Title Code=Job Category value. Both of these dropdowns get their data from a SharePoint list (but I don&#39;t think that matters in this case)</p><p>For example:</p><p>When the Job Category dropdown shows Construction, value is C</p><p>Job Title should show all of the titles such as 1C456, 2C378, 4C123, etc</p><p>TIA</p><p>Dean</p>