LTRIM(RTRIM(c.HouseNo)) + ', ' + LTRIM(RTRIM(c.Street)) + ' ' + LTRIM(RTRIM(c.Area)) + ' ' + LTRIM(RTRIM(c.City)) as Address
SELECT HouseNo + ', ' + Street + CHAR(13) + CHAR(10) --new line feed char + Area + CHAR(13) + CHAR(10) + City AS [Address] FROM [YourTableName]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)