You could always try to do an inner join with the soundex() function.

Something like this :

Select soundex('Paris Hilton'), soundex('Paris jr Hilton') where soundex('Paris Hilton') like soundex('Paris jr Hilton')

But I'm...

Sorry about the outburst... was remembering an old post from Joe Celko that went along those lines .

Anyways, I'm in this situation here...

I would hope so... but how would you explain the error then??

It's either corrupted data or conversion error.

I'm not dissing 'em...

Would you be happy if were to have open heart surgury and saw that the nurse was gonna perform the operation. On top of that she's...

you can't call an sp from a funtion.

You can't delete/update/insert into a user table either (can in table variable)

after the open statement :

Dim Er 'As Error

For Each Er In objsDB.Errors

MsgBox Er.Description...

Please do not cross post, we monitor all boards. This questions has been answered HERE

Select CrDate from master.dbo.SysDatabases where name = 'DbName'

What are you trying to do exactly in the server side process?

Can you show the before and after versions of the data?

no it won't, if you have a constraint that forbids duplicates, this is what will fail, not the foreign key.

The foreign key only makes sure that there's a match in...

No and I don't have .net installed here.

Err.. in what language did you need this already?

That's what I was about to write.

Nice job finding this yourself.

Just run the proc you just created (into a recordset)

in you don't have any records, check the errors collection for your messages, they should be there. Then you'll simply...

I already answered that question for you.

BTW, what do you mean by show?

Do you want to have a messagebox? an html (asp, aspx) file? a form?

Create an access data project. It'll use sqlserver to store the data. But you'll be able to access it as if it were residing in access.

What's the task...