USE SimpleDeploy
go

SELECT dbo.function1('Tech*Ed')
go

-- But does it behave the way WE (as in database developers/dbas) expect it to?
-- What's a good test? How does it handle NULL

SELECT dbo.function1(NULL)
go

-- What's the correct behavior? 
-- Default behavior on SQL is that concat NULL yields NULL

-- Why doesn't this seem to work?!
-- Let's go back to the function!