Skip to Content
0
Former Member
Dec 31, 2015 at 10:17 AM

CARRIAGE return sap hana

258 Views

hi expert

i try to use the carriage return in sap hana but it give me an error

DECLARE v_crlf NVARCHAR(2);

SELECT BINTOSTR( HEXTOBIN('0D0A') ) --Carriage return line feed

INTO v_crlf

FROM DUMMY;

select 'first_name' || :v_crlf || ' last name'

it give me an error messagge