Revolving around the core of technology
| Document ID: | 824 |
|---|---|
| Subject: | What functions does WinSQL support? |
| Creation date: | 7/29/09 4:59 PM |
| Last modified on: | 7/29/09 4:59 PM |
WinSQL supports every function that is supported by your back-end database. In addition, it also supports ODBC escape functions.
Example: Consider the following table:
FirstName CHAR(30)
LastName CHAR(30)
HireDate DATE
You need list all individuals who were hired on a Friday. The following query will return the desired result.
select FirstName, LastName
from employees.txt
where {fn DAYOFWEEK{HireDate)} = 6
For a complete list of supported functions, please refer to WinSQL User's Guide.
Posted by Gosa Shiferaw on 3/17/11 2:03 PM
Do you have a helpful tip related to this document that you'd like to share with other users?