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... ?? -- Matt Jarvis Eugene, Oregon USA _______________________________________________ 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/capt54ra3laweocrz+qj6ujxx6esl3j030aktzaq1ubbkjtl...@mail.gmail.com ** 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.
