MS Access LCase() Function

MS Access LCase() Function Example Convert the text in “CustomerName” to lower-case: SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers; Definition and

MS Access InStr() Function

MS Access InStr() Function Example Search for “t” in string “Customer”, and return position: SELECT InStr(“Customer”, “t”) AS MatchPosition; Definition