Name Matching

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sh0t2bts (sh0t2bts_at_hotmail.com)
Date: 02/07/05 

Date: 7 Feb 2005 06:38:54 -0800

Hi All,

I have a table with two columns that I want to match but am unsure of
how to.

The Columns are called "User_Name" and Managed_By" the user_name is
entered as "Fred Flintstone" while the Managed_By is entered are
"Flintstone, Fred".

To the human eye you can see that they are the same person but how can
i do that match in SQL?

I am using a SQL 2000 server

Many Thanks

Mark