Diffending on input value this function will returns the single value.
•UCASE() - Converts a field to upper case
•LCASE() - Converts a field to lower case
•MID() - Extract characters from a text field
•LEN() - Returns the length of a 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 is to be displayed
Showing posts with label SQL Scalar functions. Show all posts
Showing posts with label SQL Scalar functions. Show all posts
Wednesday, March 23, 2011
Subscribe to:
Posts (Atom)
