# SQL Parametrisation

## Thorsten Mürell

SQL Parametrisation allows you to put variables into your SQL statements.

Just replace the variable parts of your SQL statement with variables like ':variable' and you will be prompted on SQL execution for the value.

An example:

    SELECT *
      FROM customer
     WHERE last_name = :last_name
    ;

When you execute this SQL, you will be asked for a value for ':last_name'. This value will be quoted unless it can be expressed as an int or a float. If this is the case you can use the "Quote Value" checkbox to force the quotes around the value.