Text search with special character

I have a tracker user who wants to do an 'all text' search for &NULL. What is returned is the same as if one did an 'all text' search for NULL.  Is there a way to do an 'all text' search for a string that contains a special character?

I tried &NULL, NULL, \&NULL, \\&NULL '&NULL' - all returned the same number of results. The encoding for '&' is octal 046 and hex 26. Searching for &NULL, \046NULL and \x26NULL returned no matches.

I ended up doing this:

  grep -n '&NULL' */msg*

in the db/files/msg directory and using the msg IDs to get a list of issue ids:

  select * from issue_messages where linkid in (49635,49724,49725,50096,52671) order by 2;

There has to be a more direct way.

Tom Ekberg
Senior Computer Specialist, Lab Medicine
University of Washington Medical Center
1959 NE Pacific St, MS 357110
Seattle WA 98195
work: (206) 598-8544
email: [email protected]


------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk