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.