====== Microsoft - Microsoft SQL Server - SQL - Find - Find Leading or Trailing Spaces ======

===== Find Leading and Trailing spaces =====

<code sql>
select * from #Temp 
where name like '% ' --Will provide us values with Trailing space/s
or name like ' %'     --Will provide us values with leading Space/s
</code>

----

===== Update the records and remove leading and trailing spaces =====

<code sql>
update #Temp
set Name=LTRIM(RTRIM(Name))
where name like '% ' 
or name like ' %'
</code>