Sometimes when importing data, whitespaces sneak in at the front or back of a piece of data. This can mess up searches on the front end so you can use the script below to remove said whitespaces. You will need to know the name of the table as well as the field that needs to be changed.
update [tablename] set [fieldname] = ltrim(rtrim([fieldname]))
