Search code examples
sqlreplacesybase

What does Sybase function REPLACE() do with char() attribute?

Can anyone explain what the attribute char(10) does in this replace function? Doesn't seem to do anything. What's the purpose in putting char(x) as search-string in replace function 

select replace('1234567890',char(10),'')
Solution

  • Control character Values

    Tab: char(9)

    Line feed: char(10)

    Carriage return: char(13)