Archives of the TeradataForum
Message Posted: Tue, 09 Oct 2001 @ 20:29:32 GMT
Then you must use three single quotes:
select '''Table A''' etc.
You are getting the 3810 error because double quotes force Teradata to accept whatever is inside them, however unlikely it may seem. It therefore thinks you are looking for a column named "'Table A'" (9 characters: tick, 'Table', blank, 'A', tick).
The proper use of double quotes is for selecting columns that are unfortunately named the same as reserved words (e.g., select "date" from badly_named_table).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|