Hi Bill,
Have you tried using dump() on the row?
It is possible that the '-' is not quite what you think it is.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 4/20/05, William B Ferguson <wbfergus_at_usgs.gov> wrote:
>
>
> SQL> set escape off
> SQL> select UPPER(regexp_replace(name,'[''''|"|;| |-|,|.]')) test_data
> 2 from names
> 3 where upper(regexp_replace(name,'[[:punct:][:space:]]'))
> 4 like ('%JGO%');
>
> TEST_DATA
> ----------------------------------------------------------------------
> A-JGOLDMININGCO
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2005 - 19:56:04 CDT
