Isn't this exactly why full-text search was invented??

You're better off starting a new thread on this board. It'll get much more exposure that way. Greatly improving your chances of getting an answer.

Good point to recall. Always validate client side first. Then revalidate on the server to be 100% sure. But I'd still go with a single transaction update...

That's a very big assumption. If the tables are read-only then it's a simple process... But if it takes a 2 way replication, you got a whole lot more...

I personally hate XML because it's too bloated so I'd go with the temp table approach. I don't think you have any other options in this case. Anyways...

Why do you need to do that?

I think you'd be better off creating an ADP (access data project). Basically the data resides on sql server only, but all the manipulations are made using access. ...

It is but friday's not always the best day. Your answer will have a better chance of being answered when it's been presented in the newsletter (next monday).

HTH.

Is there a space here before the and??

"and Person"

Also if it's really an id as a number of some sort, then you really don't need to add the quotation marks.

--create all objects

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType = 'U' and user_name(uid) = 'dbo')

DROP TABLE Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1) primary key clustered,...

No this is how html gets presented.

Ya... udf were introduced with sql 2k :-).

Glad you found the solution.

Does that mean you need more help?

Can you provide more details??