Regular Expressions in SQL

2002-12-18 Thread cbeckley
What's the easiest way to do regular expressions in an SQL query? If the answer is creating a function, does anyone have one they wouldn't mind sharing? Thanks, Chris Christopher Beckley OCPDBA, MCDBA, MCSD, EIEIO ThirdParadigm LLC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

RE: Decode

2002-09-12 Thread cbeckley
Well, if we're going to be picky :) select chr(84)||chr(104)||chr(97) ||chr(110)||chr(107)||chr(32) ||chr(71)||chr(111)||chr(100) ||chr(101)||chr(115)||chr(115) ||chr(33) from dual > > Jared, didn't you mean: > > select > chr(84)||ch