Search code examples
sqlcell

SQL skip or ignore a specific cells

I need to develop an SQL command that will skip/ignore or possibly change/modify specific cells that contain all 9's. The tables run automatically and go through each field (6 total) and the system needs to know to skip those cells that contain all 9's and NOT skip the entire row or column.

Solution

  • Since the count of 9's in the column is always 10, you can change the value to NULL using the NULLIF function.

    SELECT NULLIF(Column1, 999999999), 
       NULLIF(Column2, 999999999), 
       NULLIF(Column3, 999999999)
FROM Table