xxxxxxxxxx
SELECT *
FROM your_table
WHERE col1 IS NULL OR col1 = ''
xxxxxxxxxx
SELECT COALESCE(NULLIF(SomeColumn,''), ReplacementColumn)
FROM SomeTable
xxxxxxxxxx
WHERE ISNULL(column_name);
#Can also use
WHERE column_name IS NULL;
#Example with join
SELECT title FROM series
LEFT JOIN reviews
ON series.id = reviews.series_id
WHERE ISNULL(rating);
xxxxxxxxxx
get-childitem *.mp3 | foreach { rename-item $_ $_.Name.Replace("<<<REPEATED-TEXT-HERE>>>", "") }