C

  1. I. -
  2. II-2.5.3.
  3. II. , , . ֲ .
  4. II. , .
  5. II. , ( ),
  6. II. ֲ

.

,
ASCII ASCII (character_expression) ASCII .
CHAR CHAR (integer_expression) ASCII
CHARINDEX CHARINDEX (expression1, expression2 [, start_location]) ,
DIFFERENCE DIFFERENCE (character_expression, character_expression)
LEFT LEFT (character_expression, integer_expression)
LEN LEN (string_expression)
LOWER LOWER (character_expression)
LTRIM LTRIM (character_expression)
NCHAR NCHAR (integer_expression) Unicode
PATINDEX PATINDEX ( '% pattern%', expression)
REPLACE REPLACE (string_expression1, string_expression2, string_expression3) . 1 2 3.
REPLICATE REPLICATE (string_expression, integer_expression)
REVERSE REVERSE (character_expression) ,
RIGHT RIGHT (character_expression, integer_expression)
RTRIM RTRIM (character_expression)
SOUNDEX SOUNDEX (character_expression)
SPACE SPACE (integer_expression)
STR STR (float_expression [, length [, decimal]])
STUFF STUFF (character_expression, start, length, character_expression) ,
SUBSTRING SUBSTRING (expression, start, length)
UNICODE UNICODE ( 'ncharacter_expression') Unicode-
UPPER UPPER (character_expression)

SELECT Գ, [] + "" + Left (['], 1) + "." + Left ([], 1

FROM 볺

LEFT 볺.



|

| | | | | 3. , . | 4. | | Inline | Multi-statement |

© um.co.ua -