| Function | usage |
| UPPER(or)UCASE | Converts a field to upper case |
| LOWER(or)LCASE() | Converts a field to lower case |
| MID() | Extracts characters from text field |
| LEN() | Returns the length of text field |
| ROUND() | Rounds a numeric field to the number of decimals specified |
| NOW() | Returns the current system date and time |
| FORMAT() | Formats how a field to be displayed |
Sunday, 9 October 2011
SQL- Scalar Functions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment