× 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.



something like this?
select substr(temp,1,length(trim(temp))-1) from qtemp/temp

Thanks,
Tommy Holden



Peter Vidal <Peter_Vidal@xxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/27/2007 02:56 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
SQL: Remove a character from a string (regardless position)






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.


--------------------------------------------------------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.