I tried sp_cycle_errorlog last night and also stopped and started the instance.  I still have no logs??  

Thanks for everything!!!  Here is the code I ended up using:

UPDATE MYTABLE

SET COL2= PARSENAME(REPLACE(COL1, '\', '.'), 1) + '@' +

PARSENAME(REPLACE(COL1, '\', '.'), 2) + '.com'

WHERE COL1 LIKE '%DOMAIN\%'

go

UPDATE MYTABLE

SET...

Thank you.  With all this good info..  I'm going to try and figure it all out.  I made a copy of the table and I'll use that to test.. 

All...

Wow.   Thank you so much.   That helps alot!

Perhaps you can help with something a little more complicated? (I am SO hoping that I am NOT going to have to do this...

Here is the link for MS SQL Server 2000 sp4 download

http://www.microsoft.com/downloads/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

You will need to install the Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)

If you have Analysis Services installed along with...

That all sounds good.  thank you. I'm just having trouble getting started.  don't I need visual  studio to actually write the reports?  not sure where to get my hands on...

That's kinda what I thought too.. but the shows table does not have a genre column??  only a category column..   The category is correct.. i just can't figure out where...

The genre code is wrong for a couple of shows.. not all of them

This is the view scripted out.

CREATE VIEW dbo.VW_Genre_Catgry_Shows

AS

SELECT     dbo.Shows.Show_No, dbo.Shows.Show_Name, dbo.Shows.Show_Format, dbo.Categories.Category_Code, dbo.Categories.Category_Desc,

                      dbo.Genres.Genre_Code, dbo.Genres.Genre_Desc

FROM         dbo.Genres INNER JOIN

                      dbo.Categories ON dbo.Genres.Genre_Code = dbo.Categories.Genre_Code INNER JOIN

                      dbo.Shows ON...

awesome!  THanks

sorry..  I think I missed something on this one.. 

Thanks All.   I'm certain I would have found the sytax for the REPLACE in BOL - admittedly I didn't look - but I did try and figure out the wildcard...

Thank you so much.. both worked!!!!!!!!!!!!!!!

Kind of on the same note...  Now that I have been able to list all of my records using

select * from My_Table where show_name...

so you replace the apostrophe in  Hunter's with double quotes?

I tried it and it returned zero rows ???