in reply to Exact Match

Rather than working around the problem in Perl, your time would be better spent getting your SQL to return the correct data.

You don't say which database system you are using, but I think you want something like:

select * from description_table where description_column like '%Robert Jr.%';

To be honest, I'm surprised that your current SQL even compiles. I assume it's preprocessed in some way before it's sent to the database.

Note: Of course select * is almost always bad practice - you should replace * with the list of columns that you're interested in.

--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

Replies are listed 'Best First'.
Re^2: Exact Match
by Anonymous Monk on Jun 03, 2006 at 06:06 UTC
    Thanks for the update.. I will try your suggestions and get back.. Regards