Hi Matt, apparently the data that is being stored has blanks on the end hence why it is not working.
Thanks Frank. Frank Cazabon On 30/05/2012 12:06 PM, M Jarvis wrote: > On Wed, May 30, 2012 at 4:34 AM, Frank Cazabon<[email protected]> > wrote: >> If I pass in a full PolicyNumber like 'WLIF20120047' (the other >> parameters are passed as empty strings) I get no matches. >> >> If I pass in 'WLIF2012004%' I get matches with the policynumber >> 'WLIF20120047' >> >> Likewise if I pass in 'WLIF20120047%'. > > My first guess is that the field widths that refer to PolicyNumber are > different between the tables, and the one that works happens to be the > exact same width as the value you are sending in... ?? > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
