CONTAINS is really for full text queries; for something like this, just use like:

select * from tblAdd where address LIKE '%"%'

UPDATE tblAdd

address= Replace(address,'",'')

where address LIKE '%"%'

your post is a little thin on details, and hard to follow, so I'll post a best guess of how to do an UPDATE FROM based on your statement:

Update Table1...

this has been the fastest way I've found, because it's using index tables to count rows, rather than actually running a statemtn.

that's important to note, because if you have a...

a calculated field would do the trick: add a column to your table like this:

ALTER TABLE MYTABLE ADD

MYFIELD AS COALESCE(FIELD1,'') + '/'

+ COALESCE(FIELD2,'') + '/'

+ COALESCE(FIELD3,'') + '/'

+ COALESCE(FIELD4,'')

CreataObject assumes there is a dll registered for the object in question....the richtext control is typically registered when vb6 gets installed, and you usually don't install that on a server.

it...

In a lame attempt to get this thread back on track, I've used Jeff's Tally table to html encode and decode some text for html and xml outputs:

SELECT dbo.HTMLEncode('é')

SELECT dbo.HTMLEncode('happinéss...

as with any general question , the answer depends on more info;

how much data is being brought in? if it's a suite of small tables, it might not matter; obviously...

can't you just either declare the variables and use them in teh cte query, or throw it into a procedure with your 40 parameters with default values?

here's a very basic...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

do not crosspost; asking the same question in 4 different forums splits the answers and wastes many peoples time;

most people go to Recent Posts...Posts Added Today to find everything that...

i tried going down the CLR route to resolve this in SQL 2005...but guess what... a SQL project is not allowed to have access to an rtf richtextbox control....I guess...

i looked at the 4 special RESTORE commands that I know of in BOL:

RESTORE HEADERONLY

RESTORE FILELISTONLY

RESTORE LABELONLY

RESTORE VERIFYONLY

looks like you can find the name of the user that rant...

kewl to get a wierd error....can you paste lines 13,14,15 from your script so we can see what line 14 might be doing to cause the error?

looks like you are trying to do a sum on the web page, which is NOT the same a s a sql statement running on the server.

on the server, the...