30 Apr 2012
Tab and new line are only charcters. So you can concat them as other chars...
select ' '!! 'text' !! '
' !! 'new line text';
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
01 May 2012
Thanks, but I was asking about following:
Select '$' || x'0A' || '$';
02 May 2012
So I gues you need to be more specific on your question
How can I add Tab and new line symbol to a string without using UDF?
The answer is concat.
What is the ascii number for LF and TAB?
The answer is '0A' and '09'
or for unicode
'000A' and '0009'
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
You must sign in to leave a comment.
Hi all,
How can I add Tab and new line symbol to a string without using UDF?
Thanks.