Hello, I am new to SQL and to this site so thank you in advance for any support offered. I'm in the process of upsizing an access db to sql and I created a view to use with the access front end but I'm experiencing problems when concatenating fields. I'm concatenating fname, lname and mi but when mi is null, the entire field result is null. I'm attempting to change the default using sp_dboption. This is what I did...
USE master
EXEC sp_dboption 'model', 'concat null yields null', 'FALSE'
GO
I've also tried using the set statement for this setting without success.
Can somebody put me on the right path (syntax)?
Thanks!!