SQL 116 - SQL SERVER - String Concatenation and LTRIM RTRIM functions
englishspacedog YouTube tutorial from Canada
http://www.herostratus.ca/PC.htm
How to concatenate text and how to trim spaces
ellipsis ...
function
SELECT tblGALAXIES.GalaxyID,
tblGALAXIES.GalaxyName,
tblSTARS.StarID,
tblSTARS.StarName,
tblPLANETS.PlanetID,
rtrim(ltrim(tblPLANETS.PlanetName))
' ' + tblSTARS.StarName AS
PlanetName,
tblPLANETS.PlanetWeight
/(SELECT PlanetWeight FROM
tblPLANETS WHERE PlanetID = 3)
AS WeightInEarths
FROM tblGALAXIES
LEFT JOIN tblSTARS
ON tblGALAXIES.GalaxyID =
tblSTARS.GalaxyID
LEFT JOIN tblPLANETS
ON tblSTARS.StarID = tblPLANETS.StarID
ORDER BY
tblGALAXIES.GalaxyName,
tblSTARS.StarName,
tblPLANETS.PlanetName;