I have a question about a function called trim?

[chubby]

I seen a query that uses the word Trim...

Example: Trim([FirstName] & " " & [LastName])

I just would like to know what is trim and why is it used???

 

[Tim1]

Hiya,

TRIM is used to remove trailing spaces from a field:

Assume that in your query, the values were:

FirstName = 'Tony '
LastName = 'Blair '

Then FirstName &" "& [LastName] would give 'Tony Blair '

Whereas:
Trim([FirstName] & " " & [LastName]) would give 'Tony Blair'

Tim

 

[chubby]

Thanks Tim, that answered my question and using an example was perfect. Thanks again...