LOWER, UPPER, SOUNDEX and DIFFERENCE functions

03:11

	Content	Login

SQL Problems and solutions S. I. Moiseenko

	Transact-SQL string and datetime functions String functions in MS SQL SERVER LOWER, UPPER, SOUNDEX and DIFFERENCE functions
	The LOWER(character_expression) and UPPER(character_expression) functions convert all the characters of the argument accordingly to the lower and upper register. These functions turn out to be useful in comparison with the registerdepended strings. A pair of the interesting functions SOUNDEX and DIFFERENCE SOUNDEX(character_expression ) DIFFERENCE (character_expression _1, character_expression_2) allow us to determine the similar-sounding of words. SOUNDEX returns a four-character code to evaluate the similarity, but DIFFERENCE just properly evaluates the similarity of two comparing character strings. Being that these functions do not support Cyrillic, I refer interested to BOL for the examples of its usage. In conclusion we will adduce some functions and a few examples of the Unicode usage. string functions LOWER UPPER SOUNDEX DIFFERENCE

Холодильники Samsung

Характеристики, цены. Справочник фирм и организаций.

holodilnik.ru

Last added:

Tags

aggregate functions ALL ASCII AVG Battles Bezhaev Bismarck C.J.Date Cartesian product CASE cast CHAR CHARINDEX classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CTE data type conversion database schema DATEDIFF DATEPART DATETIME DELETE DISTINCT EXCEPT exercise (-2) exercise 19 exercise 23 exercise 37 exercise 39 exercise 46 exercise 54 exercise 55 exercise 56 exercise 57 exercise 7 exercise 70 exercise 8 exercises EXISTS FROM FULL JOIN GROUP BY grouping Guadalcanal More tags

The book was updated
yesterday

SQL Problems and solutions