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

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.


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