You are here
Home > Posts tagged "Character Functions"

Character Functions in sql

Character Functions T-SQL supports many built-in functions. Concatenation T-SQL supports two ways to concatenate strings. one with the CONCAT function and another with the plus (+) operator. Example: select CONCAT('abc', 'xyz'); Output: abcxyz Example: select LEFT('abcxyz',2) + RIGHT('abcxyz',2); Output: abyz   Substring extraction and position                                T-SQL supports built-in functions like SUBSTRING, LEFT,