help in selecting rows with low values.

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

Hi,

Is there any way where I can select rows from table with low values in the where clause?

There is a text field in my table which will be populated with low value. I want all the rows with low values in that particular column from the table. Is that possible?

Thanks,
Roshnii

Craq Giegerich · Posted: Tue Nov 25, 2008 7:40 pm

Yes, just compare with x'00'!

dbzTHEdinosauer · Posted: Tue Nov 25, 2008 7:40 pm

yes. What is the definition of the text field?

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

the column is char(30)

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

I am sorry, its not a varchar field, its a char field

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

I have to pick up rows which are either low values or ---------.
I have tried giving x'60' but it did not pick up the rows with values as ---------.

Craq Giegerich · Posted: Tue Nov 25, 2008 8:24 pm

x'60' would not be low values!

dbzTHEdinosauer · Posted: Tue Nov 25, 2008 8:36 pm

is this text column NULLABLE?

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

yes the field is nullable.

I need rows which have the value --------- also which is '606060'

Roshnii · New User Joined: 30 Sep 2008 Posts: 45 Location: bangalore

I am using Column_name IS NULL and its working.

dick scherrer · Posted: Fri Nov 28, 2008 3:12 am

Hello,

If IS NULL is working, your questions about x'00' and x'60' have nothing to do with the query that you say meets your requirement.

If the requirement is to find rows with te NULL value, why the discussion about the other hex values? Might the query be only partly working?