Home > IT Answers > Database > Microsoft Access – I would like to have the first character of a field print without the first character?
1123
5 pts.
 Microsoft Access – I would like to have the first character of a field print without the first character?
Access 97, Microsoft Access
I would like to have the first character of a field print without the first character? (ex: LC7 to print as C7, The size of the field may vary)

Software/Hardware used:
ASKED: June 5, 2008  10:42 PM
UPDATED: June 6, 2008  1:17 PM
RELATED QUESTIONS
Answer Wiki:
Hello, you can do as follows: <pre> SELECT REPLACE(MYFIELD,LEFT(MyFIELD,1),'') FROM MY TABLE </pre> Bye
Last Wiki Answer Submitted:  June 6, 2008  5:30 am  by  alessandro.panzetta   9,695 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,695 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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