Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2013 @ 15:05:38 GMT

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

Subj:   Re: Error : 3704: "0A"X not a valid Teradata SQL
From:   Dempsey, Mike

You are correct that Word's quote characters are not 'real' quote characters and must not be used in SQL.

What is odd is that those characters are '5B'x thru '5E'x so I don't know why the error message specified '0A'x - which is an [invisible] Line Feed character.

It appears that the error message was incorrect.

I will look into the possibility of replacing the 4 quote characters with real single or double quotes when text is pasted into the Query.

Mike Dempsey

  <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: 24 Jul 2020