http://www.coderecipes.net/sql-string-functions.aspx<p>SQL string functions allow you to manipulate character data effectively. Here you can find almost common SQL string functions such as ASCII, CHR, CHAR, CONCAT, LENGTH or LEN, REPLACE, LOWER and UPPER.</p>Tue, 15 Jan 2008 09:02:00 GMTen-UShttp://www.coderecipes.net/sql-ascii-function.aspxMon, 17 Dec 2007 11:04:00 GMTIf you want to find a numerical value of a character which is in range of 0 to 255 you can use SQL ASCII function.http://www.coderecipes.net/sql-char-chr-function.aspxMon, 17 Dec 2007 11:07:00 GMTSQL CHAR or CHR function converts an integer in range 0-255 into a ASCII character.http://www.coderecipes.net/sql-concat-function.aspxMon, 17 Dec 2007 11:09:00 GMTSQL CONCAT function is used to concatenate two or more strings.http://www.coderecipes.net/sql-length-function.aspxMon, 17 Dec 2007 11:11:00 GMTSQL LENGTH function to get the length of a string we can use SQL LENGTH or LEN function.http://www.coderecipes.net/sql-replace-function.aspxFri, 29 Aug 2008 02:00:00 GMTSQL REPLACE function replaces every occurrence of the string specified as the searched string with the replacement string.http://www.coderecipes.net/sql-upper-lower-case-functions.aspxThu, 27 Dec 2007 10:47:00 GMTSQL Upper and Lower functions allow you change the uppercase and lowercase of a string.http://www.coderecipes.net/sql-substring.aspxTue, 15 Jan 2008 09:30:00 GMTIn order to get a part of a string we can use SQL SUBSTRINGfunction.