Home > IT Answers > Development > Trim 2 right characters in a string
Scooby999
5 pts.
 Trim 2 right characters in a string
SQL, Strings
In sql how would I trim off the 2 right characters in a variable length string

Software/Hardware used:
ASKED: June 27, 2008  8:13 PM
UPDATED: June 30, 2008  6:47 PM
RELATED QUESTIONS
Answer Wiki:
SELECT SUBSTRING(daColumn FROM 1 FOR LENGTH(daColumn)-2) ... ;o)
Last Wiki Answer Submitted:  June 30, 2008  2:36 pm  by  RudyLimeback   440 pts.
All Answer Wiki Contributors:  RudyLimeback   440 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _