SELECT DECODE(ENCODE('password', 'sec'), 'sec') -> password When I try: SELECT DECODE(ENCODE('password', 'sec'), 'SUBSTRING("secret",1,3)'); or without quotes around SUBSTRING function
This does not produce the same output, i am not sure what the problem is. Ben __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php