Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 19 Jun 2006 @ 22:07:37 GMT


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


Subj:   Re: BTEQ SQL error: Failure 3706 Syntax error
 
From:   Michael Larkins

Hi Michele:

Your request works in Queryman because if fixes bad SQL for you since you have the Allow SQL extension box checked.

Specifically you are using the wrong syntax for the substring. Instead, you are using the syntax for substr.

Correct syntax:

     substring( FROM 1 FOR 11)
     substr(,1,11)

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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