According to this http://thunderguy.com/semicolon/2003/04/26/oracle-empty-string-null/ and the oracle DBA and developers here testing against '' an empty string will not work with oracle.
Now I will just dig around and pull that query out of the code and I should be good. - Shawn Plummer Systems Manager On Aug 30, 2012, at 10:03 PM, Shawn Plummer <plum...@geneseo.edu> wrote: > Running that query returns no results. > > I will look into the indexing. I know we run the rt full text indexing > command every 15 minutes. As for the database indexes I will have to look > into it. > > - Shawn Plummer > Systems Manager > >