Tuesday, June 13, 2017

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server.

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server. Actually in the SQL server data base the spaces are looking like empty string only. For the first time all peoples will think of its space kind and will use LTRIM () & RTRIM () functions. It will not clear the tabs space and all. So this type of issue...
Read More »