I am running a simple sql server pivot query. I tried to google this but because the word "like" is such a common word I can't get a good answer.
Can I run a PIVOT query using the LIKE syntax ['%data%'] instead of using the absolute value in the field? I have a large dataset where some of the values may be different but at least one word will be constant. I am trying to avoid a long and arduous clean-up process.