trim space in front of data so i can use it in select query

[Guest]

could someone give me an example of how to use Ltrim function please?

 

[Guest]

In SQL

Select LTrim([FieldName] As NewFieldName From TableName

Or, in query design add a field in the query
NewFieldName: LTrim([FieldName]