How to update the data in a specific column with random data?

Asked May 19 '16 at 07:07

Active May 19 '16 at 07:17

Viewed 39 times

I have a table with 1000's of records. I want to update a specific column with pure string values. I have referred some previous questions and I got this:

DECLARE @LENGTH INT = 4;
UPDATE bbvasample SET [Agency Name]=
  SUBSTRING(REPLACE(CAST(NEWID() AS character(255)),'-',''), 1, @LENGTH)

When I work it out, I got data combinations of string and integers, so I want pure string data. I am new so excuse mistakes, if any. Thanks in adv :)

edited May 19 '16 at 07:17

jarlh

42,561
8
45
63

asked May 19 '16 at 07:07

Sridhar Paiya

Tag the dbms used, product specific SQL involved. (Perhaps SQL Server?) – jarlh May 19 '16 at 07:11
there are many articles out there on populating with random data.... – Mitch Wheat May 19 '16 at 07:12
and who's to say an agency name can't contain a numeral? "Level 7 Widgets" – Mitch Wheat May 19 '16 at 07:13
@jarlh Yes I am using sql server – Sridhar Paiya May 19 '16 at 07:14
@MitchWheat Agency name is just a sample,I am gonna use it for user name. – Sridhar Paiya May 19 '16 at 07:15
Check out Martin Smith's answer to [this question.](http://stackoverflow.com/questions/4558403/how-can-i-generate-random-strings-in-tsql) – Zohar Peled May 19 '16 at 07:26
@ZoharPeled so where to mention my existing table name and column there ? – Sridhar Paiya May 19 '16 at 07:45
That answer is on how to create random strings in sql-server, you can adapt it to your needs but it will have to write the update statement. I currently don't have the time to write a proper answer, perhaps later today. – Zohar Peled May 19 '16 at 08:50

How to update the data in a specific column with random data?

0 Answers0