Ltrim RTrim In query 2

[SeeWard]

Hi is it possible to use the
Ltrim(Rtrim(fieldname)) in a query? If not where should it go? I'm trying to clean up data and it's proving to truly cleaning 'wash, rinse, repeat...wash, rinse...etc'

 

[alvechurchdata]

You can use calculated fields in a query and assign a name to the new field. Something like:

Select LTrim(FieldName) As TrimField
  From MyTable

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[SeeWard]

Thank you very much. Do you know if it's possible to trim the field upon enetering it in a Form. Could I validate it at all in that way?

 

[MoLaker]

I think you will find the entry is right trimmed automatically when entered in a form control. But, instead of LTrim() & RTrim(), you could use plain ol' Trim() which trims leading and training spaces.

But, back to your original question concerning use of trim functions in a query, yes you may. You can create an Update query where the Update To is the trim function

UPDATE {tablename} SET {tablename}.{fieldname} = Trim({fieldname})

 

[SeeWard]

I find all of your suggestions and comments very useful. This is exactly why I search here before anywhere else. Thank you!!