[SOLVED] selecting based on colum only containing values.

[Yammyguy]

Hello, I'm hoping someone can answer my question..

 

I'm trying to run a query to return only rows that have a value in a specific column.  I've already tried running this:

 

SELECT * FROM [TABLE]
WHERE DEVICE_ID = 60
AND DEVICE_CUSTOMER IS NOT NULL

 

The problem is that this still returns blank rows because it's NOT NULL, but it doesn't have any data.  I would like only the rows that HAVE some sort of text in there?

 

Any quick solutions anyone?

 

Thanks in advance!

 

~C.

[trq]

SELECT * FROM [TABLE]
WHERE DEVICE_ID = 60
AND DEVICE_CUSTOMER <> ""

[Yammyguy]

SELECT * FROM [TABLE]
WHERE DEVICE_ID = 60
AND DEVICE_CUSTOMER <> ""

 

DOUBLE QUOTES!!!!      I tried this query, but only used single quotes...

 

..duh.

 

Thanks!