Use Value as a Literal

The Use Value as a Literal selection, on the Assign Condition dialog box, places text in the query exactly as it appears in the Value is box. In most cases, you must not select this option so that the Query Builder can determine the correct SQL statement. However, in some instances, advanced users may want to type specific text that should be written directly to the SQL statement.

For example, you can type a system function specific to the database (such as GETDATE on a Microsoft SQL Server database) and select Use Value as a Literal. This ensures that GETDATE is included in the SQL statement without quotation marks.