SQL – SQL Server STR() Function
The SQL Server STR() function returns a number as a string.
The SQL Server STR() function returns a number as a string.
The SQL Server STUFF() function deletes a part of a string, starting at a specified position, and then inserts a new part into the string at that position.
The SQL Server SUBSTRING() function extracts a specified number of characters from a specified position in a string.
The SQL Server TRANSLATE() function returns the string from the first argument after the characters in the second argument are translated into it.
The SQL Server TRIM() function removes leading and trailing spaces (default) OR other specified characters from the start or end of a string.
The SQL Server UNICODE() function returns an integer value (the Unicode value) for the first character of the input expression.
The SQL Server UPPER() function converts a string to upper-case.
Thanks for your support!
All are affiliate links. Thank you for your support!