SQL String Fonksiyonları

ASCIIReturns the ASCII value for the specific character
CHARReturns the character based on the ASCII code
CHARINDEXReturns the position of a substring in a string
CONCATAdds two or more strings together
Concat with +Adds two or more strings together
CONCAT_WSAdds two or more strings together with a separator
DATALENGTHReturns the number of bytes used to represent an expression
DIFFERENCECompares two SOUNDEX values, and returns an integer value
FORMATFormats a value with the specified format
LEFTExtracts a number of characters from a string (starting from left)
LENReturns the length of a string
LOWERConverts a string to lower-case
LTRIMRemoves leading spaces from a string
NCHARReturns the Unicode character based on the number code
PATINDEXReturns the position of a pattern in a string
QUOTENAMEReturns a Unicode string with delimiters added to make the string a valid SQL Server delimited identifier
REPLACEReplaces all occurrences of a substring within a string, with a new substring
REPLICATERepeats a string a specified number of times
REVERSEReverses a string and returns the result
RIGHTExtracts a number of characters from a string (starting from right)
RTRIMRemoves trailing spaces from a string
SOUNDEXReturns a four-character code to evaluate the similarity of two strings
SPACEReturns a string of the specified number of space characters
STRReturns a number as string
STUFFDeletes a part of a string and then inserts another part into the string, starting at a specified position
SUBSTRINGExtracts some characters from a string
TRANSLATEReturns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument.
TRIMRemoves leading and trailing spaces (or other specified characters) from a string
UNICODEReturns the Unicode value for the first character of the input expression
UPPERConverts a string to upper-case

ref: https://www.w3schools.com/sql/sql_ref_sqlserver.asp

Yazı oluşturuldu 38

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Benzer yazılar

Aramak istediğinizi üstte yazmaya başlayın ve aramak için enter tuşuna basın. İptal için ESC tuşuna basın.

Üste dön