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?

Thanks
Victor

--
Message posted via http://www.dbmonster.com