leftmost char from a field - 03-25-2008 , 01:04 PM
Do we have something like
select right(left(contract_no, 2),1) from contract;
I want to get the second character of the contract.
btw, can anyone suggest a good book about the informix sql synatx for me?
Message posted via http://www.dbmonster.com