do you mean something like ... where translate(substr(my_column,2,1),'1234567890','0000000000')) = '0'
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote