Keep in mind if either ColumnA or ColumnB are NULL, ColumnC will be NULL. 

(oops, Ghost already said this... sorry - may want...

I use a GOTO for the next record.  There are better ways, I am just stuck in the mud - not that big a deal. 

This "may" help as an...

Try surrounding your updates with BEGIN TRANSACTION... COMMIT TRANSACTION and that may block the row for the Trigger to work...

You will need to figure out how you want to loop, but this should work. 

SELECT CONVERT( integer, LEFT( '123.45', (CHARINDEX( CHAR(46), '123.45') - 1)))

Try this with out the...

It sounds as if you need to display it in that format.  Follow what the others have suggested, then at the end, CONVERT( varchar(10), YourDate, 101) for the recordset back to...

THANKS!  I guess since NULL is nothing (hence NULL cannot equal NULL), we assumed the DEFAULT would take precedence.  But, NULL is a legitimate "value" in SQL Server even if...

Thank you all for your inights and suggestions!!  I knew this was the place to ask this question.   

My wife agreed with many...

We may need more information.  Is this processing one record at a time when you call it from another stored procedure and that may be your bottleneck. 

Maybe post a...

You might want to be little more specific.  Are you running this from a GUI and need something passed to let the client know?  Are you running this from Query...

You should be able to do this with a SELELCT statement using CASE. 

For exampl CASE WHEN DiscountValue = 0 THEN (UnitPrice * Quantity) ELSE ((UnitPrice * DiscountValue) * Quantity)...

You might want to be more specific.  Things like tabs, line feeds, carriage returns will save.   What other types of things are you looking for? 

good addition jon!  that way a CASE statement can go through the numerous fields she/he desires and determine whether 3 instances match her/his logic. 

I don't completely understand your explaination and it has been some time since I played with Access.  But, I would suggest you look up using a CASE statement.  Maybe someone...

Can you give us a snippet of your code and the error you are getting? 

Also, Query Analyzer only displays, (by default) 256 characters.  So if you are seeing your...