Setting blank text in variable

Last Post 23 Sep 2008 12:51 PM by GoodFella3993. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GoodFella3993
New Member
New Member

--
23 Sep 2008 12:51 PM
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, '') <>'' '
You are not authorized to post a reply.

Acceptable Use Policy