Generating characters with SQL

Do you know a simple way to generate long strings in SQL? Something like the x operator of Perl ('go' x 1000 is 'gogogogogo....')

And even better: how to generate a long *random* string?

TIA Received on Mon Dec 08 2003 - 06:06:38 CST