Document information

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

Details

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.

User comments

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.

Your name:
Your email:	Hide my email address
Verification code:	Enter the verification code you see above more submitting your tip
Tip:	Please limit tips to 1000 characters