I’m running a query using MS Excel and pulling data from an Access database. I have how to use the wizard and have very little knowledge of SQL. I know of a function called “ltrim” and “rtrim”. These functions remove spaces for the left or the right of the data being queried. I know that there are other functions such as “ltrim” and “rtrim”. I just don’t know what they are. Could someone direct me to a list of all the possible functions and what each function does?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.