Return to Question

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC\[R]S123456' ESCAPE '\' [The edit added ESCAPE '\'.]

 

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC\[R]S123456' ESCAPE '\' [The edit added ESCAPE '\'.]

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC\[R]S123456' ESCAPE '\' [The edit added ESCAPE '\'.]

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC\[R]S123456' ESCAPE '\' [The edit added ESCAPE '\'.]

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC[R]S123456' ESCAPE '' <- the edit

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?

This edit came up in the queue the other day, which I rejected as I felt it should have been a comment, and I checked, was already a comment by the editor.

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html

LIKE 'WC[[R]S123456' or

LIKE 'WC\[R]S123456' ESCAPE '\' [The edit added ESCAPE '\'.]

Should work.

A few minutes later it came up again and was approved.

Was this a valid edit? Was I wrong to reject it?