Sign in

Microsoft.com

Microsoft

Remove From My Forums

CORRUPTED T-SQL THREAD: list of all special characters in mssql string

Question
0

Sign in to vote
MODERATOR:

As I was posting the following query (modified version of a previously posted query by someone else) with results, the thread corrupted. I included the result set (which I don't this time). Possible culprit: CHAR(5) in the results set.

Link: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/89c6de08-c6bd-49ec-80c5-eb3f9a4feaee

DECLARE @str VARCHAR(50) SET @str = '[azAB09ram#reddy@wer45' + CHAR(5) + 'a~b$' SELECT DISTINCT poschar FROM MASTER..spt_values S CROSS APPLY (SELECT SUBSTRING(@str,NUMBER,1) AS poschar) t WHERE NUMBER > 0 AND NUMBER <= LEN(@str) AND NOT (ASCII(t.poschar) BETWEEN 65 AND 90 OR ASCII(t.poschar) BETWEEN 97 AND 122 OR ASCII(t.poschar) BETWEEN 48 AND 57)

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
- Edited by Kalman Toth Friday, September 28, 2012 3:36 PM
Monday, January 4, 2010 3:42 PM

Reply

|

Quote

Answers

0

Sign in to vote
I fixed the thread. I'll also have my team file a bug regarding the character that breaks threads from being rendered.

Thanks.
Forums Test Lead
- Proposed as answer by Naomi NModerator Wednesday, January 13, 2010 11:36 PM
- Marked as answer by Kalman Toth Wednesday, January 13, 2010 11:44 PM
Wednesday, January 13, 2010 9:24 PM

Reply

|

Quote

All replies

0

Sign in to vote
I fixed the thread. I'll also have my team file a bug regarding the character that breaks threads from being rendered.

Thanks.
Forums Test Lead
- Proposed as answer by Naomi NModerator Wednesday, January 13, 2010 11:36 PM
- Marked as answer by Kalman Toth Wednesday, January 13, 2010 11:44 PM
Wednesday, January 13, 2010 9:24 PM

Reply

|

Quote
0

Sign in to vote

Thanks.
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Wednesday, January 13, 2010 11:06 PM

Reply

|

Quote