RSS flow:

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.