SELECT TRY_CONVERT(NVARCHAR(1), 234523) also gave me an error but SELECT CONVERT(NVARCHAR(1), 234523) rendered the * . I'm on SQL 2014 so I'm guessing it might be different with 2012 since...
Here's how I compute it: My length at a position varies from two to eight years with an average of five. I have been at my current company six years....
Just wanted to add that Andy Warren is excellent. I've listened to him speak at our SQL Saturday in Orlando. Just keep in mind he deals mostly with PCI rather...
My job requires SOX compliancy as well. Regardless, it is always a good practice to remove all PI data. At a minimum I would clean Last Names, Addresses, SSNs, Driver...