We have below string column and having below data and I want to find Null count present in string columns means how many times null value(”) present in front of id column present in select statement using big query. Don’t use string position. Expected output: Answer Below is for BigQuery Standard SQL if to apply to sample data from your