Okay here ya go...

Here's the table & the indexes..

CREATE TABLE [dbo].[EventItems_rob](

[LogId] [int] NOT NULL,

[Company] [varchar](50) NOT NULL,

[CompanyId] [int] NOT NULL,

[Department] [varchar](50) NOT NULL,

[DepartmentId] [int] NOT NULL,

[CompanyCRN] [varchar](50) NOT NULL,

[DepartmentCRN] [varchar](50)...

Thanks Jeff

Thanks Matt

It would be far more efficent if you put the values that are in the function into a look-up table and then use a join to update the values...

Thanks for the quick replys.

I'm thinking I should create a new table with state, county, abbrev...

Am I still missing something?

Sure, will do.

Sorry for the touble.

Like this Gail?

INSERT INTO Eventitems_rob (LogId,Company,CompanyId,Department,DepartmentId,CompanyCRN,DepartmentCRN,TitleUnit,TitleUnitId,State,County,OrderNo,OrderId,UserCompany,UserCompanyId,UserName,UserId,Source,Event,EventTime,EventValue,PI2Status,PI2LineCount,PI2RequestTrigger,PI2PrimaryRequestValue,Comment)

SELECT '418504535','Chicago Title','134','ServiceLink PA','845','00021','00090','01','910','CA','Madera','1734995','33806768','ServiceLink','190','Christina Young','1538','TitlePoint','Image-Recorded','Sep 29 2008 12:53PM','MA:2008 00020606','','','','',''

SELECT '358982648','PlantMaintenance','268','Arizona Locating','1132','PLADM','00009','Arizona Locating','1224','CA','Madera','[NONE]','29553378','PlantMaintenance','268','PM2 Janice Marquez','9837','TitlePoint','Image-Recorded','Jun 30 2008 1:01AM','MA:2

SELECT '358982677','PlantMaintenance','268','Arizona Locating','1132','PLADM','00009','Arizona Locating','1224','CA','Madera','[NONE]','29553378','PlantMaintenance','268','PM2 Janice Marquez','9837','TitlePoint','Image-Recorded','Jun 30 2008...

It would be great if the results could match the output of the orignal statement, as this is part of a larger proc that I would prefer not to change....

Sorry for the delay Jeff,

I followed the directions in your signature. Let me know if this is incorrect.

CREATE TABLE [dbo].[EventItems_rob](

[LogId] [int] NOT NULL,

[Company] [varchar](50) NOT NULL,

[CompanyId] [int] NOT NULL,

[Department]...

The method I posted above worked...but gives me fewer records...so I'm stuck..

Geez long night, I meant the where..

Thanks Gail.

Here it is..

Thanks again Gail.

K, will do thanks Gail.

Sure Gail, I understand completely.

I'm kinda new to this site, so wasn't sure if I should post something so large.

I'll work on breaking it down.

~Thanks