Kbase 15186: SQL LIKE and date fields S/E 223
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
SQL LIKE and date fields S/E 223
The SQL LIKE phrase is not meant to operate with DATE fields --
it operates with character strings only. Reference
section 4.2.2.2 of the 1992 standard.
Trying to operate on a DATE field may result in the following error:
** Incompatible data types in expression or assignment. (223)
Progress Software Technical Support Note # 15186