# ASP- Omitting Results from a database?

**URL:** <https://forum.kirupa.com/t/asp-omitting-results-from-a-database/178969>\
**Category:** programming\
**Created:** [February 15, 2006, 7:38pm UTC](https://forum.kirupa.com/t/asp-omitting-results-from-a-database/178969 "2006-02-15T19:38:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![burns](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@burns](https://forum.kirupa.com/u/burns)\
**Post date:** [February 15, 2006, 7:38pm UTC](https://forum.kirupa.com/t/asp-omitting-results-from-a-database/178969/1 "2006-02-15T19:38:39Z")

</div>

Hi,

Does anyone know of a way of omitting a specific record returned from a database query,

For example, if I have a query that returns **all** areas from a database table i.e. spain, cyprus, greece, morocco, is their a way that i can change the query to return all areas except for example, greece?

Many Thanks