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

Question
-
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
Answers
-
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 N Wednesday, January 13, 2010 11:36 PM
- Marked as answer by Kalman Toth Wednesday, January 13, 2010 11:44 PM
All replies
-
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 N Wednesday, January 13, 2010 11:36 PM
- Marked as answer by Kalman Toth Wednesday, January 13, 2010 11:44 PM
-
Thanks.
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com