|
<< Click to Display Table of Contents >> SQL LENGTH |
  
|
|
<< Click to Display Table of Contents >> SQL LENGTH |
|
The SQL keyword LENGTH is not available in the Borland BDE Local SQL implementation of SQL.
To test for a specific string length you may use one af the following clauses.
To test for strings shorter than position:
WHERE
SUBSTRING(field FROM position) = ''
To test for strings having length equal to or longer than position:
WHERE
SUBSTRING(field FROM position) <> ''
Supplementary notes on LocalSQL added by Niels Knabe
