All Forums Database
DonJuan 1 post Joined 05/15
29 May 2015
SPACE(n) as Name

Hi! I have to join two tables and one of those tables do not contain the field in a table so I need to create a space of 50 characters , the error is marked me to write this sentence SPACE ( 2) AS Number

dnoeth 4628 posts Joined 11/04
01 Jun 2015

There's no SPACE function in Teradata.

cast('' as char(50))

 

Dieter

You must sign in to leave a comment.