finding negative numbers

[tmoney101]

Hey,

I would like to write a sql statement for sql server that will pull all records from a table that have a negative number in a certain field. any ideas on how to do this?

thanks.

[longneck]

where certain_field < 0

[rewy]

SELECT * FROM tab WHERE field<0

"tab" is the name of your table, and "field" is the name of that certain field