Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Query help needed
From:   Geoffrey Rommel

  Thank you Mr. Rommel, but I actually want the single quotes to appear in the query output. If I remove the double quotes that will not happen.  

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


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023