If your question is only regarding relational data then BOL says:

[INTO]

Is an optional keyword that can be used between INSERT and the target table.

However, if it is about "analysis...

My job's not one of moderator but it would be NICE to keep the tone even & friendly and not resort to personal comments - everybody's entitled to an opinion/viewpoint...

plumber, electrician or a database developer/administrator - in this constantly changing/evolving world - DATABASES ARE INDISPENSABLE & HERE TO STAY

The bottom line - it's all about keeping the cash registers ringing constantly - the question to ask is - if you were a company (pick corporate giant) & you...

what about vb ?! (have never worked with Access so can't comment on it)

Have you tried using a "Replace" function?! Either directly with the ~ character or with the acii value (126) ?!

Ian seems to have other constraints that he cannot use within an UDF - you can use a select statement to return recordsets from the procedure & I've used concatenated...

Ian - here's some stuff that might help you start looking in the right direction....(re:BOL)

Returning Data from a Stored Procedure

Microsoft® SQL Server™ 2000 stored procedures return data in four forms:...

Companies can rely on imported slave labor so they treat you like dirt - employees know that if they lose this job then there are either zillions of "slaves" ready...

I once interviewed for a job where the tech lead actually told me that he considers people who have jumped several jobs over as many years more valuable because it...

eg: this may help get you started.....

CREATE PROCEDURE MyProcedure

@RowIDInt,

@NumericVal Int

AS

DECLARE @ReturnVal Int

BEGIN

UPDATE MyTable

SET NumericVal = NumericVal + @NumericVal

...

Ian - you can get more than a success/failure return from a stored procedure - you can get back a single value; a recordset - whatever you want!

Use a stored procedure.

You use a timestamp field so that changes to a row can be detected......

What is the advantage of this as opposed to using - say - a rowlock ?!?!

Chris/Remi - I have several questions:

1) when I go to specify a datatype - I do not see "rowversion" in the dropdown.

2) BOL specifically says "To record the times data...