How to check if a given text is found in a table

i have a SELECT statement in mssql that searches in a column for "WEB_PAGE" but its raising an error and i believe its because there is STILL nothing on it that has "WEB_PAGE"..how do i check my table if it has something before doing the DELETE statement?

an error shouldn't be raised simply because the search fails to find a match. For that matter it shouldn't error if you try to delete a record which isn't there either. Check your SQL, or post it so i can have a look.

Cheers