PRESENTATION

Useful Scalar Functions in MS Access. Function Description UCASE(c) Converts a field to upper case LCASE(c) Converts a field to lower case MID(c,start[,end]) Extract characters from a text field LEN(c) Returns the length of a text field INSTR(c) Returns the numeric position of a named character within a text field LEFT(c,number_of_char) Return ... ................
................