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

Question

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

Any help is appreciated.

Answer 1

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

• IF
• EXISTS
• SELECT