Thanks to you both. Why an earth does Microsoft assume people know these things? They are supposed to be the leaders in this stuff. If anything when you hover the...

It seems that noone mentioned the most obvious problem with using a string field as a primary key:

There appears to be no way to have the string field work as...

One more thing on the full-text index. Is that fully contained within the database? I noticed when I created it that I first had to create a catalog. When I...

Oh does that do the same thing? I did not know about the split function.

Yes, since my application is web-based, I have written mine in Vb Script. In case anyone else is also stuck on this, here it is:

[Code]

Function Parse2Array(sBuffer)

Dim lEnd

Dim i

Dim sData...

Yes, I have no doubt that the fulltext indexing is far more efficient, but efficiency is not the problem I am having, see my last post.

Your Contains example using the Or operator is still no different from a Like using the or operator.

Select * from MyTable where textfield like '%Cat%' or textfield like '%Dog%'

Is essentially...

Thanks for that, that worked perfect. The only additional thing needed was to create the empty table before hand.

Ok worked out that there is no import option in Managmenet Studio express, but you can export from other programs such as Access using a DSN.

Thanks Lynn, i will try that. Is there any reason why "Union All" comes after the first three tables but not the final table?

And to answer your first post, all...

Yes, I am still stuck on getting the find and replace to work, see my last post from last Thursday (Sept. 25th).

...

Ok, did not want to offend any Irish people here, sorry for that.

And yes it is my fault for not making it clear at the beginning that I wanted...

Well thats just stupid, why would I write code to specificaly find and replace all instances of single quotes with double quotes...

Ok I am getting close, I have managed to select all of the records that have the apostraphe, using

like '%''%'

select * from (TABLE NAME) where (FIELD NAME) like '%''%'

Now...

Is the first argument the table name? The database name?

Will that replace every single instance of the " ' "

Replace ( [Table Name Here] , ''', ' ')