Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Random 10 Char Values
Message
 
To
26/05/2005 01:20:55
Simplicio Jison Jr
Davao, Philippines
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Random 10 Char Values
Miscellaneous
Thread ID:
01017716
Message ID:
01017727
Views:
21
Hi,

> how to generate random 10 character values just like sys(2015) of Foxpro.

The following T-SQL expression returns a string that looks like SYS(2015) string:
'_'+LEFT(REPLACE(NEWID(),'-',''),9)
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform