SQL Step by Step Tutorial

SQL SERVER TRY_CAST()

SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.

SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.

SQL Server RTRIM() function is used to trim trailing characters from a character string.

SQL Server LTRIM() function is used to trim leading characters from a character string.

SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .

SQL LOWER() function converts all the characters in a string into lowercase.

SQL LEN() function is used to count the number or length of character in given string. It returns integer value always and null for empty string.

SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.