CARRIAGE return sap hana

[Former Member]

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

[former_member183582]

Hi

Can you share the error message?

Irfan

[Former Member]

Could not execute 'SELECT BINTOSTR( HEXTOBIN('0D0A') ) --Carriage return line feed INTO v_crlf FROM DUMMY' in 2 ms 244 µs .

SAP DBTech JDBC: [337] (at 67): INTO clause not allowed for this SELECT statement: line 3 col 3 (at pos 67)