SQL SERVER Question

[vsusi]

Do anybody know how to give a line feed (or carriage return) in SQL Server query or in Crystal Reports?

I want something like below

Select f_name + (carriage return) + l_name from employee

If it is not possible then how to do in Crystal Report (formula)?

Thanks for breaking ur heads for me.

[WuzZ]

SQLServer Carriage Return = Char(13)
SQLServer Line Feed = Char(10)

You really need to combine the both for a complete new line to be recognised in text or rtf format.

So in your example it would look something like this:

Select f_name + Char(13) + Char(10) + l_name from employee

WuzZ

[vsusi]

Looks Simple. But didnt come in my mind.