Access question...

[Odoggy5]

should be pretty easy.

I just want to exclude a string of text from the results of a query, how can I do it?

[redhead]

Exclude a string ??
Something like:

$text = "";
$res = mysql_query("SELECT * FROM some_table WHERE (id = \"$SOME_ID\")", $DB_LINK);
while($row = mysql_fetch_array($res))
  $text .= str_replace("some text", "", $row);
mysql_free_result($res);
echo $text;

Or are you thinking more in the terms of only selecting items, where the text is not pressent ?

[Odoggy5]

yaeh
I want to select items where the text is not present.

[sde]

select * from table where field IS NULL

or

select * from table where field=''

[Epsilon]

That brings up a question. Can you use the not operator in a MySQL statement, like:

select * from table where field!='something'

[redhead]

SELECT * FROM table WHERE something = something AND NOT some_other;
If I remember correct, it's been a while since I used the combined select.

[bdl]

To further expand on sde's statement, you can combine the two easily to match any column without value or with an empty string, e.g.

SELECT * FROM sometable WHERE field IS NULL OR field = '';

Please note you can't use 'WHERE field = NULL' because any operation on NULL like that always returns NULL.

And yes you can use either the <> or != operators to signify the NOT.