# Using regular expressions on SQLServer

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

## Main concept

The regular expression function is not built into all different databases environments. This is why you need, when using some databases, to create a User-Defined Function (UDF) to extend the functionality of the database server.

For example, the following databases natively support regular expressions: MySQL, PostgreSQL, Oracle 10g, Ingres, etc., while Microsoft SQL server does not.

After you create the regular expression function, you should use Talend Studio to declare that function in a specific database before being able to use regular expressions on analyzed columns.

### In this section

* [Using a regular expression function on SQL Server](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-02/using-a-regular-expression-function-on-sql-server)