Detecting Trailing Spaces in a nvarchar Field

[EddieN1]

I have a table on SQL Server with fields defined as type nvarchar(255). Some of the rows have data with trailing spaces in that field. I don't know how they got there, but I identified them with a SQL Server query using the DATALENGTH function. How can I do the same thing with an Access query. When I use the LEN function, it automatically excludes the trailing spaces. Thanks.

[ranman256]

if right([field],1) = " "

to remove:
trim([field])

[EddieN1]

That worked. Thanks.