After reading this nice post about a stored procedure to create random numbers i figured i needed a function for more flexibility. Here’s how to create a user defined function to generate some random characters with a length of up to 100 characters.
comes up with: H34ja1xQMm
First we need to create a simple view that is being used by our UDF:
And now our CreateRandomString UDF:
If you've read this far you might as well follow me on Twitter here.