Sections

 Actions

 Language:
 RSS flow:
 104 visitors online.

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.

 

 

 

Back