Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 9. Conditional statements and loops . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . behaviour of NULL in Firebird SQL, points out common pitfalls and shows you how to deal safely with expressions that contain NULL or may resolve to NULL. If you only need a quick reference to refresh your memory (Firebird 2+) In Firebird 2 and higher only, you can test for the null-encompassing equality of two expressions with “IS [NOT] DISTINCT FROM”: if ( A is distinct from B ) then... Chapter 2. NULL support in

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 4.1. Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 4.1.3. Conditional Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 4.1.4. NULL in Expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230 6.1.14. Common Table Expressions (“WITH … AS … SELECT”) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231 6.2. INSERT

Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete AI SQL Assistance (ChatGPT) User Guide fades from to between values AlbumId #80c6ff #8000ff 1 and . 10 You can use regular expressions for matching complex values. Otherwise, you can be artistic and, for example, paint rows with filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template

filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template right-click the cell, then click on the context menu F11 Order/Filter and then click one of the expressions. The third way is to filter data by a cell value using the filter icon in the column header. To particular word search. Regular expressions Enable to use regular expressions in the search. In the search field, you can use for Ctrl+Space autocomplete regular expressions templates. Wrap search Enable

filter criteria button ( ) next to the field or press . Enter You can apply ready-to-use SQL expressions or SQL expression templates via the context menu. To select a ready SQL expression or a template right-click the cell, then click on the context menu F11 Order/Filter and then click one of the expressions. The third way is to filter data by a cell value using the filter icon in the column header. To used for managing query conditional expressions. To add a new conditional expression use the button on the right - a new instance will be added and the Add default conditional expression WHERE will