InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 12:02:46 GMT20http://forum.strataframe.net/FindPost7986.aspxIn the BrowseDialog, on a string field, when Using the "EndsWith" advanced option, I noticed that the query was putting it together with an "&amp;" instead of a"%".&nbsp; </P><P>I went into the SqlDataSourceItem.vb, line 627, it has</P><P>[codesnippet]<FONT size=2></P><P>loParam.Value = </FONT><FONT color=#a31515 size=2>"&amp;"</FONT><FONT size=2> &amp; </FONT><FONT color=#0000ff size=2>CType</FONT><FONT size=2>(loWhere.Values(0), </FONT><FONT color=#0000ff size=2>String</FONT><FONT size=2>)</P><P></FONT>[/codesnippet]</P><P>I changed that to</P><P>[codesnippet]<FONT size=2></P><P>loParam.Value = </FONT><FONT color=#a31515 size=2>"%"</FONT><FONT size=2> &amp; </FONT><FONT color=#0000ff size=2>CType</FONT><FONT size=2>(loWhere.Values(0), </FONT><FONT color=#0000ff size=2>String</FONT><FONT size=2>)</P></FONT><P>[/codesnippet]</P><P>and it seems to be working fine now.&nbsp; I'm not too well versed on Oracle, and VFP data sources etc., so I didn't know if those should be changed as well, but since we aren't using any of those, I guess I'll be ok :-)</P><P>Thanks,</P><P>Robin GiltnerMon, 09 Apr 2007 16:58:03 GMTRobin J Giltnerhttp://forum.strataframe.net/FindPost7997.aspxNice catch, Robin.&nbsp; I updated it on this end as well and it will be included in the next update.&nbsp; Thanks.Mon, 09 Apr 2007 16:58:03 GMTStrataFrame Team