Category: SQL

Use of SUBSTRING Function in SQL

Use of SUBSTRING Function in SQL: (1) “SUBSTRING” function is used to extract characters from the string with defined length and position. (2) Let’s take an example to extract the first two characters from Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) …

Use of REVERSE Function in SQL

Use of REVERSE Function in SQL: (1) “REVERSE” function is used for reversing the string. (2) Let’s take an example of reversing the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens as shown. (5) After doing …

Use of REPLACE Function in SQL

Use of REPLACE Function in SQL: (1) “REPLACE” function is used to replace characters within the string. (2) Let’s take an example to replace ‘A’ with ‘T’ in Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens …

Use of LOWER Function in SQL

Use of LOWER Function in SQL: (1) “LOWER” function is used for converting text in lower case. (2) Let’s take an example to convert the text of Vendor Name into the Lower case as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new …

Use of UPPER Function in SQL

Use of UPPER Function in SQL: (1) “UPPER” function is used for converting text in upper case. (2) Let’s take an example to convert the text of Vendor Name into Upper case as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query …

Use of RIGHT Function in SQL

Use of RIGHT Function in SQL: (1) “Right” function is used to get a number of characters from a string that’s starting from right. (2) Let’s take an example to get a character from the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. …

Use of LEFT Function in SQL

Use of LEFT Function in SQL: (1) “LEFT” function is used to get a number of characters from a string that’s starting from left. (2) Let’s take an example to get a character from the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. …

Use of LEN Function in SQL

Use of LEN Function in SQL: (1) “LEN” function is used to calculate the length of the string. (2) Let’s take an example to calculate the length of “The Universe” as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens …

Use of DATALENGTH Function in SQL

Use of DATALENGTH Function in SQL: (1) “DATALENGTH” function is used to calculate the length of the string. (2) Let’s take an example to calculate the length of the “Name” field in Vendor Table as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that …

Use of CONCAT_WS Function in SQL

Use of CONCAT_WS Function in SQL: (1) “CONCAT_WS” function is used to concatenate more than two strings with specific values. (2) Let’s take an example to Add four strings with value “space” ‘ERP Consultors’, ‘Provide’, ‘Best’, ‘Service’ as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. …