Count Number of Pdf Files

Recently I had been tasked with having to count the number of Pdf Filenames within a table. The challenge was that the column can have multiple filenames within a column separated by a commas. My solution was to create a case statement within the query for the count in a row column and then sum […]