Single quote ... Contatenation problem

[Azita79]

Hi All,

I am trying to put this expression into a nvarchar variable, but I am having problems with single quotes!

Here is the expression
(ISNULL(installer.installername,'') + , + ISNULL(Installer.Dba, '') + , + ISNULL(Installer.BusName,'')) as Installer

SET @strInstaller = the above expression

@strInstaller is declared locally as nvarchar(1000)

 

[Azita79]

never mind

I got it
:->

 

[chiph]

If you're using ADO or ADO.NET, using Parameter objects gets around this problem, plus several other potential problems. Highly recommended.

Chip H.