SQL Tips and Tricks

SQL Tips

Remove carriage returns from SQL request

Sometimes, when we want to use an SQL request in a script, the result contains many lines. To avoir this, we have to use the replace function:

select replace(replace(TableColumn, char(13), ''), char(10), '') from YourTable

with TableColumn as the column which returns more than one line, and YourTable the table name.