Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2001 @ 20:29:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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).

--wgr

	<Prev	Next>		<<First	<Prev	Next>	Last>>