# Create Functions

This part of the tutorial shows how to create functions that are used to develop the stored procedures. This tutorial uses user-defined functions (UDFs). For related information, refer to [CREATE FUNCTION (UDF)](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-function-udf.md).

> **📝 Note**: The **SQL Editor** only runs the queries that you select, so ensure you have them all selected before selecting **Run**.

Run the following SQL commands to create the user-defined functions (UDFs):

```sql
USE trades;

DELIMITER //

CREATE OR REPLACE FUNCTION marketcap_to_DECIMAL(s varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL) RETURNS decimal(18,2) NULL AS
   DECLARE
     m CHAR(1) = SUBSTR(s, LENGTH(s), 1);
     raw_v DECIMAL(18,2) = SUBSTR(s, 2, LENGTH(s) - 1);
     v DECIMAL(18,2) = NULL;
   BEGIN
       IF m = "B" THEN
         v = raw_v * 1000;
       ELSE
         v = raw_v;
       END IF;
     RETURN v;
   END //

DELIMITER ;
```

***

Modified at: October 10, 2024

Source: [/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/create-functions/](https://docs.singlestore.com/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/create-functions/)

(An index of the documentation is available at /llms.txt)