×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi list!
I have a file (with a couple of thousand records in it) that has a field
called FNAME (10/A) and I want to be able to remove the last character of
the value. I may have:
FILAX
TEMPERED
IGLANDT
So after the execution of the SQL, I want to have:
FILA
TEMPERE
IGLAND
How I do that in SQL?
Thanks!
Peter Vidal
MAPICS IT Technical Support Team / SR System Analyst
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com
"The wisest mind has something yet to learn."
George Santayana (1863 - 1952)
--------------------------------------------------------------------------------
Attention:
This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.
--------------------------------------------------------------------------------
midrange.com
