Setting blank text in variable

Last Post 23 Sep 2008 11:51 AM by GoodFella3993. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
GoodFella3993
New Member
New Member

--
23 Sep 2008 11:51 AM
I am trying to set a string variable to accept two single quotes: ''

SET @hp_business_unit = @hp_business_unit + ' OR CD.business_unit_name IS NULL OR CD.business_unit_name = '''


or even

SET @hp_business_unit = 'ISNULL(CD. business_Unit_name, '') <>'' '


Acceptable Use Policy
---