list of sql functions

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?
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
In the back ... there is a great reference appendix ...with functions, macro actions etc:

"Fixing Access Annoyances"
Phil Mitchell and Evan Callahan

Also ... I would start here:

JAMcDoConnect With a Mentor Commented:
For information on functions, see

Use the left pane to navigate to various applications for information on functions etc.

I'm sure there are many other such sites.

sihar86Connect With a Mentor Commented:
Try F1 from Access

Then choose link "Table of contenst" -> Expressions -> Functions
ReyesrjAuthor Commented:
This was very useful information.

Thanks you All!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.