Name 5 commands that can be used to manipulate text in T-SQL code

Technology Community › Category: T-SQL › Name 5 commands that can be used to manipulate text in T-SQL code

0 Vote Up Vote Down

VietMX Staff asked 3 years ago

CHARINDEX( findTextData, textData, [startingPosition] ) – Returns the starting position of the specified expression in a character string. The starting position is optional.
LEFT( character_expression , integer_expression ) – Returns the left part of a character string with the specified number of characters.
LEN( textData ) – Returns integer value of the length of the string, excluding trailing blanks.
LOWER ( character_expression ) – Returns a character expression after converting uppercase character data to lowercase.
LTRIM( textData) – Removes leading blanks. PATINDEX( findTextData, textData ) – Returns integer value of the starting position of text found in the string.
REPLACE( textData, findTextData, replaceWithTextData ) – Replaces occurrences of text found in the string with a new value.
REPLICATE( character_expression , integer_expression ) – Repeats a character expression for a specified number of times.
REVERSE( character_expression ) – Returns the reverse of a character expression.
RTRIM( textData) – Removes trailing blanks. SPACE( numberOfSpaces ) – Repeats space value specified number of times.
STUFF( textData, start , length , insertTextData ) – Deletes a specified length of characters and inserts another set of characters at a specified starting point.
SUBSTRING( textData, startPosition, length ) – Returns portion of the string.
UPPER( character_expression ) – Returns a character expression with lowercase character data converted to uppercase.

Question Tags: Junior Level, T-SQL