I have a scenario where the data has to be randomized before hitting the DB tables for sensitive data fields like SSN, Salary ,AccountInfo as well as User details .Can I use the RAND () functionto do this ? Is it possible to do RAND on Date, NVARCHAR and string fields? If so, can someone help me here with syntax? Thank you.