Random Character Generation in Teradata

Database
Enthusiast

Random Character Generation in Teradata

Hi,

Please give me a idea for generating random character without using USER DEFINED FUNCTIONS
2 REPLIES
Senior Apprentice

Re: Random Character Generation in Teradata

substring('abcdefghijklmnopqrstuvwxyz' from random(1,26) for 1

Dieter
Enthusiast

Re: Random Character Generation in Teradata

Hi Dieter,

When i use this for inserting in my table its not allowing me to do

There is some data type mismatch due to usage of random() function help me in this