MySQL LEFT() Function LEFT(str,len) is a Sring function of MySQL. This method returns left side ‘len’ characters from the given string ‘str’.…
Database Tutorials
MySQL LENGTH() Function LENGTH(str) is a Sring function of MySQL. This method returns length of the given string ?str? which is measured…
MySQL MID() Function MID(str,pos,len) is a Sring function of MySQL. This method returns string of given length and position. Syntax select mid(str,…
MySQL OCTET_LENGTH() Function OCTET_LENGTH(str) is a Sring function of MySQL. This method returns length of given string. Syntax select octet_length(str); Example 1…
MySQL POSITION() Function POSITION(substr IN str) is a Sring function of MySQL. This method returns position of the given sub string in…
MySQL LCASE() Function LCASE(str) is a Sring function of MySQL. This method returns string in lower case. Syntax select lcase(‘TUTORASPIRE’); Example 1…
MySQL LOWER() Function LOWER(str) is a Sring function of MySQL. This method returns the given string in lower case. Syntax select lower(str);…
UCASE Function in SQL This string function shows all the string characters in the upper case in Structured Query Language. It converts…
LCASE Function in SQL This string function shows all the string characters in the lower case in Structured Query Language. It converts…
SQL Server Comparison Operator In SQL Server, the comparison operators are used to test for equality and inequality. These operators are used…