Will masking and sub-setting work if XML files are stored in SQL varchar(max) data sets?
Prior to SQL 2016, there is a MAX of 2000 for each column. If XML data goes beyond 2000, and SQL 2016 and up is being used, the upper limit is 8000.