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

[Peter Vidal <Peter_Vidal@xxxxxxxx>]

This worked for me:

UPDATE PVIDAL/@XFILES SET MBFILE = SUBSTR(MBFILE,1,LENGTH(TRIM(MBFILE))-1)

Thanks Tommy!!!  Your tha' man!!!!

Great weekend to all!


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

"Creativity is allowing yourself to make mistakes. Art is knowing which 
ones to keep."
Scott Adams (1957- ), 'The Dilbert Principle'

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

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.


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