Char(10) And Char(13) - SQL Server Central. Microsoft SQL Server tutorials, training &
As you see access interpretes these chars in a different way the SSMS. Obviously ([Address 1] + Char(10) + IsNull([Address 2], ' ') + Char(10) + IsNull([Address 3], ' ') + Char(10) + IsNull([Address 4], ' ')) Char(10) = newline You should provide all four...