Invalid results from a Stored procedure - with multiple punctuation characters
We have some code being developed, which is pretty basic. It works fine as straight SQL but gives unexpected results when the code is put in a stored procedure. It seems that the stored procedure do NOT work when more than one punctuation character is contained in the search string. One character in the string works as expected. More than on character does not.
The following proc doesn’t returned the expect results. call CM_ADW_WEB_SRVC_V_DD.Account_Prospect_By_Broker_P('T.I.S. LTD.');
The proc uses a view. If run a select using this view to find (exact match) broker name ‘T.I.S. LTD.' The broker is found. select * from CM_ADW_ACCT_PUB_V_DD.Broker_Reference_CURR_V where broker_name = 'T.I.S. LTD.'
Here is one that works call CM_ADW_WEB_SRVC_V_DD.Account_Prospect_By_Broker_P('BROWN & BROWN INC');
select * from CM_ADW_ACCT_PUB_V_DD.Broker_Reference_CURR_V where broker_name = 'BROWN & BROWN INC'