write trim into INSERT and SELECT Queries

[Brian Conlan]

Can anyone tell me how to write trim into INSERT and SELECT Queries

How would i add to this

SELECT master_info.master_id, FirstName, SurName, Business_Name, coveredmaster_info.Covered_id, covered.Covered
FROM master_info
JOIN coveredmaster_info ON master_info.master_id = coveredmaster_info.master_id
JOIN covered ON coveredmaster_info.covered_id = covered.Covered_id
WHERE coveredmaster_info.covered_id='varWhere'
AND master_info.Business_Name LIKE'%Name%'
OR (master_info.Business_Name LIKE'%Name%') // this is where the problem is
when the value %Name% is empty it returns all records. i think it is because of white space, i maybe wrong.