How to Trim leading and trailing tab spaces in MSSQL query : <p>I have data which has leading and trailing spaces in the string. when storing that data in database I want to trim the space in query itself before storing into DB.</p>

<p>Normal spaces are trimming properly with RTRIM and LTRIM function but if a string contains tab space,its not trimming the tab space from the input string.</p>

<p>Can anyone help me to get the string with trimmed with tab space from leading and trailing.</p>
