'String Functions in 'T-SQL - نسخة قابلة للطباعة +- منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب (http://vb4arb.com/vb) +-- قسم : قسم قواعد البيانات (http://vb4arb.com/vb/forumdisplay.php?fid=40) +--- قسم : قسم مقالات SQL SERVER (http://vb4arb.com/vb/forumdisplay.php?fid=84) +--- الموضوع : 'String Functions in 'T-SQL (/showthread.php?tid=1774) |
'String Functions in 'T-SQL - Genius Live - 01-02-14 String Functions in T-SQL
ASCII (character) : Returns the ASCII code value of the leftmost character of character
CHAR (int) : Converts the integer ASCII code int to a character CHARINDEX (search, expression, [start]) : Returns starting position (int) of first occurrence of the string search within table or string expression starting from position start DIFFERENCE (expression1, expression2) : Returns the difference between the SOUNDEX values of the two character expressions as an integer LEFT (expression, int): Returns part of character string expression starting at int characters from the left LEN (expression) : Returns the number of characters of the string expression, excluding trailing blanks LOWER (expression) : Returns character expression after converting uppercase string to lowercase LTRIM (expression) : Returns a character string after removing all leading blanks NCHAR (int) : Returns the Unicode character with the given integer code PATINDEX ('%pattern%', expression) : Returns starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types REPLACE (expression1,expression2,expression3) : Replaces all occurrences of the second given string expression in the first string expression with a third expression QUOTENAME (character_string[, quote_character]) : Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier REPLICATE (expression, int) : Repeats a character expression a specified number of times REVERSE (expression) : Returns the reverse of a character expression RIGHT (expression, int): Returns part of character string expression starting at int characters from the right RTRIM (expression) : Returns a character string after removing all trailing blanks SOUNDEX (expression) : Returns a four-character (SOUNDEX) code SPACE (int) : Returns a string of int spaces STR (float_expression[, length[, decimal]]) : Returns character data converted from numeric data STUFF (expression1, start, length, expression2 ) : Deletes a specified length (length) of characters from expression1 and inserts another set (expression2) at a specified starting point (start) of expression1 SUBSTRING (expression, start, length) : Returns part of character, binary, text expression or image expression starting from position start with length length UNICODE (char) : Returns the Unicode int value for the first character of char UPPER (expression) : Returns a character expression after converting lowercase string to uppercase |