InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:31:28 GMT20http://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspx[quote][b]LondonNick (4/30/2010)[/b][hr]A very similar script is in BOL if you look up CHAR.[/quote]Agreed... and it shouldn't be used either. ;-)For those that haven't seen it, please see the following for how a "Numbers" or "Tally" can be used as a very high performance replacement for certain types of While Loops...[url]http://www.sqlservercentral.com/articles/T-SQL/62867/[/url]There are dozens of uses for such a table.I also agree with Jon... if you find something that may be useful, it's impossible to know if it posted somewhere else or even in BOL. Nothing wrong with posting something you may think is useful even if it's documented in BOL. After all, there are still a lot of folks that don't even know what BOL is never mind having actually read it from top to bottom.Sat, 01 May 2010 17:07:40 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspx[quote][b]Jon McGhee (4/30/2010)[/b][hr]Cool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site. If I don't find what I need, it's time to contribute code. Thanks.[/quote]I have to ask then... do you know what a Tally table is and how it works to replace While Loops? And, no, I'm not trying to be a smart guy here.Sat, 01 May 2010 17:03:13 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspxCool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site. If I don't find what I need, it's time to contribute code. Thanks.Fri, 30 Apr 2010 07:49:36 GMTJon McGheehttp://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspxA very similar script is in BOL if you look up CHAR.Fri, 30 Apr 2010 04:15:42 GMTLondonNickhttp://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspxAlternatively, using a Tally table (see link in my sig) to avoid the loop:[code="sql"]declare @x nvarchar(100)set @x = 'AZ az' + char(160) + '01' -- note: 160 is an html non breaking space SELECT SUBSTRING(@x,N,1), ASCII(SUBSTRING(@x,N,1)) FROM Tally WHERE N &lt;= LEN(@x)[/code]Fri, 30 Apr 2010 03:20:59 GMTnigel.http://www.sqlservercentral.com/Forums/Topic910830-2626-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/ASCII/70111/">convert string to ascii values</A>[/B]Mon, 26 Apr 2010 23:30:06 GMTJon McGhee