Check if a table contains a row with a specific column value

Question

In T-SQL syntax, how could I check to see if a table has a row with a a column matching a particular value? I am using SQL Server 2012 and am completely new to it.

Any and all help is greatly appreciated.

Answer 1

IF EXISTS (SELECT * FROM TABLE WHERE [column] = 'column_value')
  -- The value 'column_value' was found in column [column]

• IF
• EXISTS
• SELECT