See corrections inline.

>
>Here is my question: (and I don't understand, how to use Help to find an answer).
>
>In VFP we have:
>

>If
>  statement
>else
>  statement
>endif

>
>If we want to exit procedure earlier, we can use return in the middle (though not recommended).
>
>Here is how I'm trying to change my SP, but I don't understand, how can I close:
>
>

>/*
>   If exists, grab CartID and update LastModified field
>   otherwise insert a record and grab generated CartID
>*/
>/* The code bellow belongs to Bob Archer
>
>-- Code from Mike Levy

DECLARE @ErrCode
SET @ErrCode = 0

>IF EXISTS (SELECT CartID FROM cart WHERE UserID = @tcUserID)
>   UPDATE cart
>   SET LastModTs = CURRENT_TIMESTAMP,
>   @CartID = CartID
>   FROM cart
>   WHERE UserID = @tcUserID
    SET @ErrCode = @@ERROR
>ELSE
>        BEGIN
>	   INSERT INTO cart (UserID) values (@tcUserID)
           SET @ErrCode = @@ERROR
>
>	   SELECT @CartID = SCOPE_IDENTITY()
>        END
>
>     IF @ErrorCode <> 0   -- CNG
>        BEGIN
>            ROLLBACK TRAN
>            PRINT 'ERROR: An error occurred while attempting to insert record to the Cart Table.'
>            RETURN 4
>        END

>
>Basically, I want to check, if my insert was correct or my update was correct. In both cases, if something got wrong, I need to rollback and get out from procedure.