Get Random string function for SQL

Most of the time we need a function in sql server to add random string in any field.

So I have created a function, which accepts the guid and generates the random string form that.

IF OBJECT_ID (N'dbo.get_RandomChar', N'FN') IS NOT NULL

    DROP FUNCTION dbo.get_RandomChar;

GO

-- Function to generate the random char, if the char is less then A then use A and if it is greater then z then use Z.

CREATE FUNCTION dbo.get_RandomChar(@newguid varchar(255))

RETURNS varChar(10)

WITH EXECUTE AS CALLER

AS

BEGIN

    declare @NewStr varchar(25)

set @NewStr =''

declare @Randomint int 

set @Randomint =ABS(CAST(@newguid AS binary(10)) %100)

-- not in A to Z and a to Z  _ - space and *

if not((@Randomint >= 65 and @Randomint <=90 ) or (@Randomint >= 97 and @Randomint <=122 ) or @Randomint=95 or @Randomint=45 or @Randomint =32 or @Randomint =42)

Begin

if (@Randomint <65)

set @Randomint =65

else

set @Randomint =122

End

set @NewStr =@NewStr+ convert(varchar,CHAR(@Randomint))

return(@NewStr);

END;

GO

-- function to create random string of 10 chars.

IF OBJECT_ID (N'dbo.get_RandomString', N'FN') IS NOT NULL

    DROP FUNCTION dbo.get_RandomString;

GO

CREATE FUNCTION dbo.get_RandomString(@newguid1 varchar(255),@newguid2 varchar(255),@newguid3 varchar(255),@newguid4 varchar(255),@newguid5 varchar(255),@newguid6 varchar(255),@newguid7 varchar(255),@newguid8 varchar(255),@newguid9 varchar(255),@newguid10 varchar(255))

RETURNS varChar(10)

WITH EXECUTE AS CALLER

AS

BEGIN

    return(dbo.get_RandomChar(@newguid1) +dbo.get_RandomChar(@newguid2)+dbo.get_RandomChar(@newguid3)+dbo.get_RandomChar(@newguid4)+dbo.get_RandomChar(@newguid5)+dbo.get_RandomChar(@newguid6)+dbo.get_RandomChar(@newguid7)+dbo.get_RandomChar(@newguid8)+dbo.get_RandomChar(@newguid9) +dbo.get_RandomChar(@newguid10));

END;

GO

to use this function call  like get_RandomString(NEWID(),NEWID(),NEWID(),NEWID(),NEWID(),NEWID(),NEWID(),NEWID(),NEWID(),NEWID()) 

most of the time when we do data scramble we need such function.