SQL DISTINCT
Last updated: August 27, 2026. SELECT DISTINCT removes duplicate result rows after the selected expressions have been evaluated. Syntax Example…
SQL SELECT Statement: Retrieve and Filter Data
Last updated: August 27, 2026. The SQL SELECT statement retrieves columns and rows from one or more tables. A clear…
PHP Conditional Statements
Last updated: August 27, 2026. Conditional statements choose behavior from runtime values. Use strict comparisons when automatic type conversion could…
Create Word, Excel, and CSV Files with PHP
Last updated: August 27, 2026. Create genuine file formats instead of sending HTML with a DOC or XLS extension. Use…
Access IIf Function
Last updated: August 26, 2026. The IIf function evaluates a condition and returns one value when it is true and…
Access UCase Function
Last updated: August 26, 2026. The UCase function converts letters in a string to uppercase. Syntax Argument Description string Text…
Access Switch Function
Last updated: August 26, 2026. The Switch function evaluates condition/value pairs and returns the value belonging to the first true…
Access Sum Function
Last updated: August 26, 2026. The Sum aggregate adds the non-Null numeric values in a query group. Syntax Argument Description…
Access StrConv Function
Last updated: August 26, 2026. The StrConv function converts a string using a specified case, width, or character-set option. Syntax…