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/75721.aspxFri, 24 Feb 2012 23:58:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75721Jimmy0https://www.infopathdev.com:443/forums/thread/75721.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75721<p>Have you tried this:</p><p>not(contains(translate(d:Item, &quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;, &quot;abcdefghijklmnopqrstuvwxyz&quot;), translate(xdXDocument:get-DOM()/my:myFields/my:GearSearch, &quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;, &quot;abcdefghijklmnopqrstuvwxyz&quot;)))</p>https://www.infopathdev.com:443/forums/thread/75677.aspxThu, 23 Feb 2012 20:54:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75677shniggens0https://www.infopathdev.com:443/forums/thread/75677.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75677<p>Suggestions?</p>https://www.infopathdev.com:443/forums/thread/75586.aspxWed, 22 Feb 2012 15:36:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75586shniggens0https://www.infopathdev.com:443/forums/thread/75586.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75586<p>I created a search box to search my secondary data source.&nbsp; I&#39;m displaying my 2ds table in my form.&nbsp; I want hide rows if a field in my table contains the search field.&nbsp; However, it seems to be case sensitive when I test it.&nbsp; Is there a way around that?</p> <p>It seems that I need to somehow get this -&nbsp; translate(my:field1, &quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;, &quot;abcdefghijklmnopqrstuvwxyz&quot;) = translate(my:field2, &quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;, &quot;abcdefghijklmnopqrstuvwxyz&quot;)</p> <p>Combined with this - not(contains(d:Item, xdXDocument:get-DOM()/my:myFields/my:GearSearch))</p>