This content has been marked as final. Show 2 replies
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!