TOPIC | TEXT | SYNTAX | Example |
---|---|---|---|
ASCII | Returns the ASCII value of the first character in the string. | ASCII(string) | |
BIT_LENGTH | Returns the number of bits in a string. | BIT_LENGTH(string) | |
LENGTH | Returns the number of characters in a string. | { LENGTH | CHAR_LENGTH | CHARACTER_LENGTH } ( string ) | |
OCTET_LENGTH | Returns the number of bytes in a string. | OCTET_LENGTH(string) | |
CHAR | Returns the character that represents the ASCII value. | { CHAR | CHR } ( int ) | |
CONCAT | Combines strings. | CONCAT(string, string [,...]) | |
DIFFERENCE | Returns the difference between the sounds of two strings. | DIFFERENCE(string, string) | |
HEXTORAW | Converts a hex representation of a string to a string. | HEXTORAW(string) | |
RAWTOHEX | Converts a string to the hex representation. | RAWTOHEX(string) | |
INSTR | Returns the location of a search string in a string. | INSTR(string, searchString, [, startInt]) | |
INSERT Function | Inserts a additional string into the original string at a specified start position. | INSERT(originalString, startInt, lengthInt, addString) | |
LOWER | Converts a string to lowercase. | { LOWER | LCASE } ( string ) | |
UPPER | Converts a string to uppercase. | { UPPER | UCASE } ( string ) | |
LEFT | Returns the leftmost number of characters. | LEFT(string, int) | |
RIGHT | Returns the rightmost number of characters. | RIGHT(string, int) | |
LOCATE | Returns the location of a search string in a string. | LOCATE(searchString, string [, startInt]) | |
POSITION | Returns the location of a search string in a string. | POSITION(searchString, string) | |
LPAD | Left pad the string to the specified length. | LPAD(string, int[, paddingString]) | |
RPAD | Right pad the string to the specified length. | RPAD(string, int[, paddingString]) | |
LTRIM | Removes all leading spaces from a string. | LTRIM(string) | |
RTRIM | Removes all trailing spaces from a string. | RTRIM(string) | |
TRIM | Removes all leading spaces, trailing spaces, or spaces at both ends, from a string. | TRIM ( [ { LEADING | TRAILING | BOTH } [ string ] FROM ] string ) | |
REGEXP_REPLACE | Replaces each substring that matches a regular expression. | REGEXP_REPLACE(inputString, regexString, replacementString) | |
REPEAT | Returns a string repeated some number of times. | REPEAT(string, int) | |
REPLACE | Replaces all occurrences of a search string in a text with another string. | REPLACE(string, searchString [, replacementString]) | |
SOUNDEX | Returns a four character code representing the sound of a string. | SOUNDEX(string) | |
SPACE | Returns a string consisting of a number of spaces. | SPACE(int) | |
STRINGDECODE | Converts a encoded string using the Java string literal encoding format. | STRINGDECODE(string) | |
STRINGENCODE | Encodes special characters in a string using the Java string literal encoding format. | STRINGENCODE(string) | |
STRINGTOUTF8 | Encodes a string to a byte array using the UTF8 encoding format. | STRINGTOUTF8(string) | |
SUBSTRING | Returns a substring of a string starting at a position. | { SUBSTRING | SUBSTR } ( string, startInt [, lengthInt ] ) | |
UTF8TOSTRING | Decodes a byte array in the UTF8 format to a string. | UTF8TOSTRING(bytes) | |
XMLATTR | Creates an XML attribute element of the form "name=value". | XMLATTR(nameString, valueString) | |
XMLNODE | Create an XML node element. | XMLNODE(elementString [, attributesString [, contentString]]) | |
XMLCOMMENT | Creates an XML comment. | XMLCOMMENT(commentString) | |
XMLCDATA | Creates an XML CDATA element. | XMLCDATA(valueString) | |
XMLSTARTDOC | The string " | XMLSTARTDOC() | |
XMLTEXT | Creates an XML text element. | XMLTEXT(valueString) |
SQL basics- complete reference guide - part6 - String functions
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Your Comment and Question will help to make this blog better...