Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Single quote ... Contatenation problem

Status
Not open for further replies.

Azita79

Programmer
Joined
Jan 30, 2003
Messages
41
Location
US
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)
 
never mind

I got it
:->
 
If you're using ADO or ADO.NET, using Parameter objects gets around this problem, plus several other potential problems. Highly recommended.

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top