Yes, you can. Just use tablesort.
for example MyTable.Tablesort("Col1 ASC")
When you say trim do you mean that you just want some of the records? In this case use the filter command
For example MyTable.Filter("Col1=8")
You will find both commands in the main helpfile
all the best / Björn