how can I deal with character of hard return?

Hot Topic

problem importing csv delimited text file into a sql server 2005 table
Only for SQL GURUS - Calling external procedures from Functions
SQL Server Toolbox & Designer
I don't understand why
Failed Install of SQL Server 2005 SP1 CTP
Handling a double or float value for inserting into DataTime field.
Yukon SP performance issue
Handling variables
Where are the SSI files saved when saved to the server?
SQL Server 2005 June CTP Install Issue

SQL Server

=IIF( Statement
And/or filter field not enabled in the group filter tab
Multiple parameters
About SQL Mobile Server
SQL Instance name in web script
How to use cubes of 2000 in 2005
Proxy Account
SP2 - Need Your Feedback!
SSIS will not start after SQL Server 2005 SP1 upgrade
How Does one Save a Stored Procedure

how can I deal with character of hard return?

Hi there,

Can anybody tell me how the character of hard return expressed in SQL Server. For example if I wanna convert any hard return character in a varchar field to something else, like a space, how could I write Replace function Or if I wanna search any hard return character, how could I write where clause

thanks a lot




Answer this question

how can I deal with character of hard return?

  • Jain2005

    select char(15)+char(12)as x into #temp1

    declare @x varchar(2) --search argument
    declare @y varchar(1)   --- value to be replaced
    select @y=char(12)

    select @x='%'+Char(12)+'%'

    select x from #temp1 where x like @x

    SELECT REPLACE(x,@y,'hello world')from #temp1



  • Danny Crowell

    thanks a lot for your reply.

    a silly question, what are CR and LF standing for



  • beckerben

    CR - carriage return
    LF - line feed


  • victorashi

    You can use char(13) for CR and char(10) for LF. So you can do:
    replace( @value, char(13), space(1) )
    where col like 'test' + char(13) + '%'


  • how can I deal with character of hard return?
Answer this question