# Regular Expressions:

In the first page of the wizard, set the name of the pattern so that you can find it easily.

In the second page, set the regular pattern to be used in analyses.
The pattern must be surrounded by single quotes " ' ".
Once the pattern is created, you can drag & drop it onto a column in the Multiple Column Analysis editor.

Note:
Regular patterns are different from SQL patterns.
For example, if you search strings starting with 'S', the regular pattern is 'S.*', not 'S%'.
Please refer to the documentation of your Database Management System for more details.

See also:
MySQL Regular Expressions: http://dev.mysql.com/doc/refman/5.0/en/regexp.html
Oracle Regular Expressions: http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_regexp.htm
SQL Server 2005 Regular Expressions: https://blogs.msdn.microsoft.com/sqlclr/2005/06/29/working-with-regular-expressions/
PostgreSQL Regular Expressions: http://www.postgresql.org/docs/current/static/functions-matching.html
Informix Regular Expressions: http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/db_regexp.html
SQLite Regular Expressions: http://www.sqlite.org/lang_expr.html
DB2 Regular Expressions: http://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html