Access SQL get rid of spaces

Hi
I am using the following Access SQL statement to find distinct values.
How do I update the statement so that it shaves any spaces off the side of the word.
For example one of the text values came up as " Parents"

"SELECT DISTINCT [Applicable to] FROM [Table1] Where [School] = 'Saints'"
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Pratima PharandeCommented:

Update  [Table1]
set [Applicable to] = Trim([Applicable to])
0
 
Lee SavidgeCommented:
Use Trim()


"SELECT DISTINCT [Applicable to] FROM [Table1] Where [School] = trim('Saints')"

http://www.databasedev.co.uk/access-sql-string-functions.html
0
 
peter57rCommented:
"SELECT DISTINCT [Applicable to] FROM [Table1] Where trim([School]) = 'Saints'"
0
 
Alpesh PatelAssistant ConsultantCommented:
Using trim function.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you both
0
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.