Hi Ilan,

I think the code below can help you. Please note that the input you give must end with a space.

DECLARE

@SearchField VARCHAR(100),

@temp VARCHAR(10),

@Output...

Hi,

The following code may solve your problem :

CREATE PROCEDURE SearchProduct

( @Desc VARCHAR(50) )

AS

BEGIN

SELECT @Desc = Replace(@Desc, '''', '''''')

SELECT...