Do a search on this site as well.  Remi has posted a function that will use a table with all sorts of possible odd characters for Replacement.  We get that...

Google search mainly attributes it to Benjamin Franklin.  But I remember an old radio show and early TV guy who acted kinda hick, but always had quoteable lines like this.  Can't...

If you recieve your data with upper and lower case lettering, you can use the ASCII characters to keep the seperation.  This would make for a complicated function. 

Otherwise, I...

SCC reaper

SCC anopener

SCC adaver

SCC alipso

SCC undrum

That will work too.  But since he already displaying DiscoDate, it seems to me to six of one, half a dozen of the other...

I think your DISCONTINUEDDATE < DATEADD(D, 1, DATEDIFF(D, 0, GetDate())) constriant is not correct.  Basically it gives you tomorrow, hence, 2006 records will not be included. 

I threw this...

That did Noel.  Thanks!!  

The Update works perfectly.  (I originally wrote the function using the Original table name we will inevitbably use this function upon, then I made a test table with another name. ...

Alright.  I've changed these as suggested.  Note: I also removed the IF @@ROWCOUNT = 0 RETURN.  And I changed the Update/Insert constraint to use [Amount] instead of Dollars ( WHERE Old.[Amount]...

Thank you all!  Unfortunately, it is not working when I do an Update, (have not tried the Insert yet).  Please note: The actual column Updated is not Dollars, it is another...

I have tried using both "inserted" and "deleted" for the update section of this Trigger and neither changes the column [Dollars]. 

I must be doing something wrong, but I cannot...

Argh!  Bof' of yer.  But you is better at 'dis stuff 'dan I be.    (must all 'dem yars' a skoolin'....) 

Basically two ways:

CREATE PROCEDURE sp_myStoredProcedure

      @PERSON_ID varchar(5) OUTPUT,

      @PERSON_SUR_NM integer,

      @PERSON_FIRST_NM integer,

      @ADDRESS_ID integer OUTPUT,

      @ADDRESS_TEXT varchar(2000) OUTPUT

AS

GO

--  OR  --

CREATE...

We can?   

(poor Jason Carlson if he is getting emailed on this...) 

You need to add an "AS".  I would also suggest using the following

IF EXISTS( SELECT * FROM sysobjects WHERE id = object_id( N'[dbo].[sp_myStoredProcedure]')

     AND OBJECTPROPERTY( id, N'sp_myStoredProcedure') =...