SQL - create a string with bracket if not null
I like to create a string with bracket if not null, but return a blank string '' if null.
e.g. if the string is 'ABC', I will like to get (ABC)
if the string is null, I will like to get an empty string ''
How will I do that?
e.g. if the string is 'ABC', I will like to get (ABC)
if the string is null, I will like to get an empty string ''
How will I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER