Re: alias and select filter from sql

vchu via DBMonster.com wrote: > thanks a lot :) > > sorry I do have one more question... do we have something like > > select right(left(contract,2),1) from contract; > > so that i can get the second char of the contract; > > Thanks > Victor [cutting] select contract[2] from contract; Not that you need it here but have a look at the regexp datablade - it should be in the standard IDS release http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_regexp.html Cheers Paul