We help IT Professionals succeed at work.

Help with query not returning column name

JCONNELLY626
JCONNELLY626 asked
on
170 Views
Last Modified: 2014-08-02
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
Comment
Watch Question

Software Engineer
CERTIFIED EXPERT
Top Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.