I too get the point about cardinality issues but the example really is more of a logic flaw than anything else. The example you provided has some serious issues that...

Fields don't display stuff they simply store data. In this case...

I have used this plenty over the years and have never...

Actually the cities do NOT cross state lines. The metropolitan areas cross state lines but they have separate...

spam reported

And here is another one that Lowell wrote (same caveats about production ;-)):

CREATE PROCEDURE sp_UGLYSEARCH

/*

--Purpose: to search every string column in a databasefor a specific word

--returns sql statement as...

Here is an old cursor based solution I wrote for just this sort of thing. Keep in mind this is NOT fast. Do NOT run this (or the previous one)...

Hi and welcome to SSC. There seems to be something missing here. First Chrissy asked you to post ddl (create table statements) and sample data (insert statements) along with desired...

If your new destination is actually a datetime, which i...

That's because you have data somewhere in there that can't be converted to a datetime.

What is the question here?

Shaun Dayaram (2/7/2012)

For my own sanity, I need the following explained to me. It was an issue we picked up in a PROD environment.,

eg.

CREATE PROCEDURE dbo.my_proc

...

Not a lot of detail to go on here but your replace statement did exactly what you told it to do.

declare @Tag_Data varchar(200) = '2''10"'

select @Tag_Data = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@TAG_DATA,'"','\quote\'),'@','\at\'),'^','\carat\'),'|','\pipe\'),'=','\equal\') + '^'

select...

I would recommend not using the local copy and always use the online copy anyway. There are frequent changes and updates to the documentation and your local copy will not...

What is the datatype of your new column? I suspect it is another nvarchar(255). Please use the proper datatypes. You have datetime information put it in a datetime column.

Look at...