I'm a newbie to DotNetNuke and recently finished doing my first module. During development, the module worked like a charm so last night I created the installation package and attempted to deploy it another instance of Nuke to see if the installation worked. The installation of the presentation layer and BLL went without a hitch, however the SQL installation went bad.

What I have below is a segment of the sqlprovider file, the segment that is causing the problems:

...

CREATE PROCEDURE {databaseOwner}{objectQualifier}ListCompanyDirectory
 @FindThis VARCHAR(50)
AS

SELECT
 [Index],
 [Location1],
 [Location2],
 [Ext],
 [FullName]
FROM
 {objectQualifier}CompanyDirectory
WHERE
 (Ext like '%' + @FindThis + '%') or (FullName like '%' + @FindThis + '%') or
  (Location1 like '%' + @FindThis + '%')  or (Location2 like '%' + @FindThis + '%')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

...

The error output for the stored procedure is the following:

CREATE PROCEDURE dbo.ListCompanyDirectory
 @FindThis VARCHAR(50)
AS

SELECT
 [Index],
 [Location1],
 [Location2],
 [Ext],
 [FullName]
FROM 
 dbo.CompanyDirectory
WHERE
 (Ext like '%' @FindThis '%') or (FullName like '%' @FindThis '%') or
  (Location1 like '%' @FindThis '%')  or (Location2 like '%' @FindThis '%')

Please note that the "+" sign simply disappears. I have no idea why this is happening and would appreciate any help you guys can offer.

Thanks