Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
select strFastbeteckningTrakt + ' ' + strFastbeteckningBlock + strFastbeteckningTecken + convert(VARCHAR(10), intFastbeteckningEnhet) as Fastighet, strAnlnrWill mostly give desired result:Fastighet strAnlnrHEDBY 2:3 45678But for some rows these can be null:strFastbeteckningBlockstrFastbeteckningTeckenwhich will cause this:Fastighet strAnlnrNULL 45678when i want this:Fastighet strAnlnrHEDBY 3 45678