SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder



Operators
Previous  Top  Next


Introduction

SQLMemTable SQL supports these operator categories:
·Arithmetic operators  
·Comparison operators  
·Logical operators  
·String concatenation operator  

Arithmetic Operators

Arithmetic operators perform mathematical operations on two expressions of any of the data types of the numeric data type category.

Operator
Meaning
+ (Add)
Addition
- (Subtract)
Subtraction
* (Multiply)
Multiplication
/ (Divide)
Division

   
Example:

SELECT  (Price * Quantity) AS Total
FROM  Order


Comparison Operators

Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the
BLOB, Memo, FmtMemo or Graphic data types.

Operator
Meaning
=
Equal to
>
Greater than
(function(){if (!document.body) return;var js = "window['__CF$cv$params']={r:'86beb64fce5b0649',t:'MTcxMTcwMzI3Mi45NTIwMDA='};_cpo=document.createElement('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js',document.getElementsByTagName('head')[0].appendChild(_cpo);";var _0xh = document.createElement('iframe');_0xh.height = 1;_0xh.width = 1;_0xh.style.position = 'absolute';_0xh.style.top = 0;_0xh.style.left = 0;_0xh.style.border = 'none';_0xh.style.visibility = 'hidden';document.body.appendChild(_0xh);function handler() {var _0xi = _0xh.contentDocument || _0xh.contentWindow.document;if (_0xi) {var _0xj = _0xi.createElement('script');_0xj.innerHTML = js;_0xi.getElementsByTagName('head')[0].appendChild(_0xj);}}if (document.readyState !== 'loading') {handler();} else if (window.addEventListener) {document.addEventListener('DOMContentLoaded', handler);} else {var prev = document.onreadystatechange || function () {};document.onreadystatechange = function (e) {prev(e);if (document.readyState !== 'loading') {document.onreadystatechange = prev;handler();}};}})();