Tara (4/8/2009)

---

Ok,i'll put in with some example.

I have tableA with CCode

and would...

You can also check this out:

--- sample table

CREATE TABLE #CheckIn

(

CheckInID INT IDENTITY(1,1)

,UserID INT

,Comment VARCHAR(50)

)

--- insert some sample data

INSERT INTO #CheckIn (UserID, Comment)

SELECT 1, 'A'

UNION ALL...

It isn't REPLACE that is doing this, it is your collation. In a case-insensitive collation 'a' = 'A'. As shown by your own example, in a case-insenstive collation...

Please don't double post. It fragments answers.

Continue replies here.

The issue is due to your using a case insensitive collation. Look at the following:

DECLARE @str VARCHAR(100)

SET @str = '1234567890'

SELECT REPLACE(@str collate Latin1_General_CI_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_CS_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_BIN2,CHAR(179),'_')

Could you successfully move the backup file you created locally to the UNC location?

Luke L (4/8/2009)

---

A few months back Jeff was soliciting feedback for a topic similar to "Why do we need this?" He was attempting to figure out why people kept...

Glad to hear it worked. Just so you know, it is just common curtesy to let people know if your problem has been solved and how. This is...

Lynn Pettis (4/7/2009)

---

I did a little more reading, Jeff....

Curious, you respond to Jerry, but not a word about wether or not my suggested change helped you or not? Sorry, but something is missing there, don't you think?

Jeff Moden (4/7/2009)

---

Heh... the way I diffuse it at work is I tell the offender to go to his/her "corner" and come back when they calm down. Hasn't failed...

If you are using SQL Server 2005, something like this may also work:

WITH StudentAddr (

RowNum,

StudentID,

Zip,

...

1. What version of SQL Server are you using?

2. Please provide us with the DDL for the tables involved in the query. You can

...

That's...

What are your indexes on these two tables?

MagicTSD._SMDBA_._TELMASTE_ tm

MagicTSD._SMDBA_._TELDETAI_ td