---
title: "Explain the various functions available for manipulating the character data in Database."  
description: "Explain the various functions available for manipulating the character data in Database."  
author: "Revati S Misra"  
published: 2023-04-04  
updated: 2023-04-05  
canonical: https://www.mindstick.com/forum/157686/explain-the-various-functions-available-for-manipulating-the-character-data-in-database  
category: "database"  
tags: ["database", "mysql", "sql server"]  
reading_time: 2 minutes  

---

# Explain the various functions available for manipulating the character data in Database.

[Explain](https://www.mindstick.com/forum/157854/what-is-system-debugging-explain-some-system-debugging-tools-used-in-modern-computer-systems) the various [functions](https://www.mindstick.com/forum/160140/explain-the-role-of-functions-as-a-service-faas-in-serverless-computing) available for manipulating the [character](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character) [data in Database](https://www.mindstick.com/forum/34103/how-to-insert-data-in-database-using-sencha-touch-extjs).

## Replies

### Reply by Krishnapriya Rajeev

In a database, character [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) can be manipulated using various functions and they can perform various tasks such as data cleansing, data transformation, and data validation. Some of the most commonly used functions are listed below:

- **SUBSTRING:** The SUBSTRING function is used to extract a substring from a string. It takes three arguments: the source string, the starting position, and the length of the substring.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/ffc1b5a7-608b-4ef7-a7fa-88893a4d3ffe.png)

- **LENGTH:** The LENGTH function is used to get the length of a string. It returns the number of characters in the string.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/e2672fcc-b9c6-4759-90b4-171d65e34afb.png)

- **CONCAT:** The CONCAT function is used to concatenate two or more strings together. It takes two or more arguments and returns a single string.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/d8592c86-de04-4a1c-a260-76da72fa6752.png)

- **UPPER and LOWER:** The UPPER function is used to convert all characters in a string to uppercase. The LOWER function is used to convert all characters in a string to lowercase.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/d0877558-b72b-45aa-85bf-722de96b0359.png)

- **REPLACE:** The REPLACE function is used to replace a substring in a string with another substring. It takes three arguments: the source string, the substring to be replaced, and the substring to replace it with.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/46433f8e-6ae0-435b-bfec-4fe5b6a95012.png)

- **TRIM:** The TRIM function is used to remove leading or trailing spaces from a string. It takes one or two arguments: the source string and the character(s) to be trimmed.![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/59ef5d03-e6dd-4590-896f-a9fcb3cf9eee.png)
- **INSTR:** The INSTR function is used to find the position of a substring in a string. It takes two or three arguments: the source string, the substring to be searched, and the starting position (optional).

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/6a2f7395-b6b8-4099-a593-52d8337ad299.png)

- **INITCAP:** The INITCAP() function capitalizes the first letter of each word in a string.

![Explain the various functions available for manipulating the character data in Database.](https://www.mindstick.com/mindstickforums/48e8957e-86dd-4881-88a2-3c8920dc9c12/images/7472202c-d0ae-4416-9f1a-0b8c7b813b51.png)


---

Original Source: https://www.mindstick.com/forum/157686/explain-the-various-functions-available-for-manipulating-the-character-data-in-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.