<div>
Thanks you, quite simple solution that allued me. &nbsp;Learning this stuff on the fly, tried a few similar things but not this one. &nbsp;I have another one I'll be posting shortly that I can't figure out.
</div>


Thanks you, quite simple solution that allued me.  Learning this stuff on the fly, tried a few similar things but not this one.  I have another one I'll be posting shortly that I can't figure out.

<div>
<div class="content wysiwyg-content">
help with this sql query. &nbsp;It does not return the first column name for the Film_strCode. &nbsp; I&quot;m looking to only return the right 6 characters. &nbsp; <br />
<br />
SELECT &nbsp; &nbsp;right(tblFilm.Film_strCode<wbr />,6), tblFilm.Film_strTitle, tblFilm.Film_strCensor, tblFilm.Distrib_strCode, tblDistributor.Distrib_str<wbr />Name<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; tblFilm INNER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tblDistributor ON tblFilm.Distrib_strCode = tblDistributor.Distrib_str<wbr />Code
</div>
</div>


help with this sql query.  It does not return the first column name for the Film_strCode.   I"m looking to only return the right 6 characters.   

SELECT    right(tblFilm.Film_strCode,6), tblFilm.Film_strTitle, tblFilm.Film_strCensor, tblFilm.Distrib_strCode, tblDistributor.Distrib_strName
FROM         tblFilm INNER JOIN
                      tblDistributor ON tblFilm.Distrib_strCode = tblDistributor.Distrib_strCode

Help with query not returning column name

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.