Are Data Extension values case sensitive when querying with SQL query activity?
I found this to be the case when querying
WHERE Status = 'Active' that it ignored records with a status value of "ACTIVE".
I suppose I could use
WHERE Status LIKE LOWER ('Active'), but I had no idea that querying the data extension values were case sensitive. Anyone else come across this?