[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Random text generation

Hello all,

I have a need to generate a random emplid to be used in a select statement.  
The emplid is a mixture of text and numeric characters (such as "B2D7XG").  If 
I can generate the first three characters, I'll be able to use the 'LIKE' 
operand and get a decent sample.  Has anyone developed code for a situation 
such as this?  Any advice will be appreciated.  Thanks!

                                                                                
- Tony