Adding onto
Original Griff's answer; and depending on your needs, you could set up a value to replace
null(s) as needed. I typically use an empty varchar for this.
DECLARE @PossibleNull VARCHAR(32)
DECLARE @NullReplacement VARCHAR(1) = ''
SELECT 'abc' + Concat(@PossibleNull, @NullReplacement)
If you are wondering,
Concat
is preferred over the MS SQL only
IsNull
function as it is part of the ANSI language spec and can also be chained over multiple "replacement" values.