Oh ok, so something like:

SELECT WRid, WRenteredDate, WRcurrentStatus, WRclaimNumber, WRstatusUpdated, WRsendToID, WRbillToID, WRrequestorID,

IsNull(sendto.COcontactNameLast,'NA') AS 'Send To',

IsNull(billto.COcontactNameLast,'NA') AS 'Bill To',

IsNull(req.COcontactNameLast,'NA') AS 'Client Rep'

, coalesce(PayDay,(DEaltKeyValue * 1), CAST('0.00' AS Int)) as...

Wow, that's a lot simpler-looking than my original query...

Also, when I ran your query, I received a "Syntax error converting the varchar value '40.39' to a column of data type...

Thanks for the fast reply.

It is indeed classic ASP.  So I would just do a tot_count = tot_count+1 type deal at the end of each function.

What is HTH?

yes sir

thanks for your help

be nice to a semi-new-to-SQL girl...

anyway, I forgot I already looked that up, that's how I knew it might be a devide by zero issue.

ARITHABORT

Terminates a query when an overflow or divide-by-zero...

I believe recreating the table would be too risky....

What does that option mean anyway?

What does that mean anyway?

So everytime a user saves(UPDATES), I'll need to do this?

SET ARITHABORT ON

GO

UPDATE TABLE1

SET col1=blah1

SET col2=blah2

SET col3=blah3

WHERE ID='blah'

GO

SET ARITHABORT OFF

I got the error again!

Here is the exact wordage:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE failed because...

Ok, I tried that...I'll see if I get the error again.

THANKS!  M

It wasn't there before, and after I deleted that index/column, it stopped.  So it must be that.

ALTER TABLE Inet.dbo.dmvrequest ADD

DRclaimRaw  AS LEFT(REPLACE(DRclaimNumber, ' ', '')), (256)

GO

CREATE NONCLUSTERED INDEX IX_Temps_DRclaimRaw ON...

Everything is working good now...except that I'm occassionally getting an error that would indicate a divide by zero issue....

Here is my completed statement:

ALTER TABLE Inet.dbo.dmvrequest ADD

 DRclaimRaw  AS LEFT(REPLACE(DRclaimNumber, ' ',...

Ray:

I'm such an idiot.  You were right, I forgot the COLUMN keyword in my DROP statement.  Once I added that, it worked beautifully!

Thanks!

I'm trying to drop a column, but I get that error:

Server: Msg 3728, Level 16, State 1, Line 1

'claimraw' is not a constraint.

Server: Msg 3727, Level 16, State 1,...

Here's the best I could find...but after looking at it, I'm not sure if this is even possible without ruining the table.

ALTER TABLE table

{ [ ALTER COLUMN column_name

    {...