[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Help with query not returning column name

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
1 Solution
Paul JacksonCommented:
It's because you are using a function on the column try:

SELECT    right(tblFilm.Film_strCode,6) as Film_strCode, tblFilm.Film_strTitle, tblFilm.Film_strCensor, tblFilm.Distrib_strCode, tblDistributor.Distrib_strName
 FROM         tblFilm INNER JOIN
                       tblDistributor ON tblFilm.Distrib_strCode = tblDistributor.Distrib_strCode
JCONNELLY626VP ITAuthor Commented:
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.

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now