4 Replies Latest reply: Nov 18, 2013 6:25 AM by Shashank Seth RSS

    concat problem in script

    Shashank Seth

      Hi Geniuses,


      When I am concatenating 20 with one column it gave me wrong result. Below is the script



          '20' & Right([Fiscal Year],2) AS FY ,

           [Fiscal Year]







      where Fiscal Year is FY10, FY11,FY12,FY13


      The desired result is 2010,2011,2012,2013


      Result which I am Getting 20,2010,2011,2012,2013


      I want to remove that unwanted 20


      Thanks in advance