1

I have a problem with my SQL Stored Procedure when special characters are input. For example in my Home Country Filter, I have input "Còte D'Ivoire", and I cannot generate a Report/Result because of the "'" and "ò".

Error: There were invalid inputs found on this page. Please make sure you've typed valid inputs.

Code:

IF  @DISPLAYCOUNTRYCD = 1
    BEGIN
        SET @SubClause = @SubClause + 'EPVW.CountryNm as COUNTRYCD,'
        SET @SelectClause = @SelectClause + 'COUNTRYCD as [Home Country],'
    END

Where the "EPVW" is the name of the Table, and CountryNm is the Column Name. It is retrieving values from that Table.

Please help.

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
yenyen2792
  • 11
  • 2

0 Answers0