Sql Stored Procedure with parameter that include single quote -FAIL

Hello all,

I try to insert data into sql server table by calling sql stored procedure with parameters. 

my problem is that when one of the parameters include single quote i got exception. and the process fail.

Here is an example  of how i call the stoerd procedure:


EXEC [dbo].[spInsertIECMazkirotPermissionForm]


if Street value is  AB'C  for example it fail.

*  I have to use ItemProperty

0 Kudos