2 Replies Latest reply: Jan 19, 2017 1:42 PM by Wallo Atkinson RSS

    Right function

    Mike Sawyer



      I use a script that loads the field "PS #", which is 9 characters.  But, I only want to load the 7 characters on the far right of the string (each record is preceded by a "E.", and I don't want to included those 2 characters in the script).


      I tried this and it is not correct:



      "PS #" Right(TRIM(),7) AS "PS #",


      What is the correct syntax/statment to load these records?


      Thanks very much for any help!