billandmiss
IS-IT--Management
- Nov 8, 2005
- 3
Does anyone have a simple example of doing this in Teradata SQL?
I want to concatenate 'Test Text' & MyFieldName
Thanks
I want to concatenate 'Test Text' & MyFieldName
Thanks
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
sel 'Test Text ' || MyFieldName as mytext
from MyTable;
sel 'This' || 'is' || 'a' || 'test.' as mytext;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
mytext
------------
Thisisatest.
sel 'This ' || 'is ' || 'a ' || 'test.' ;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
((('This '||'is ')||'a ')||'test.')
-----------------------------------
This is a test.
SELECT field_1, (field_2||field_3||field_4||field_5||field_6), field_7, count(*) cnt