search question

[Joey Martin]

I have an nvarchar field called bathrooms.
These have entries like 2,3,2.5, etc.
It's the decimals that get me.
I want to be able to search for all listings with at least x bathrooms.

If I select all with at least 2 bathrooms, how can I get the ones with
2.5 to show. Is this possible or do I need to reconfigure the field
type?

Thanks

 

[Bob Lehmann]

Why are you using nvarchar for numbers? Use a numeric datatype for the
column.

Bob Lehmann

 

[Jeff Cochran]

I have an nvarchar field called bathrooms.
These have entries like 2,3,2.5, etc.
It's the decimals that get me.
I want to be able to search for all listings with at least x bathrooms.

If I select all with at least 2 bathrooms, how can I get the ones with
2.5 to show. Is this possible or do I need to reconfigure the field
type?

nvarchar isn't the best datatype for a column of number...

And yes, change the datatype and do a IF Bathrooms >= 2 THEN in your
search.

Jeff

 

[Joey Martin]

Okay, so I did this. How come my decimals do not show up? I type 1.5 and
only 1 shows...hmmm...

 

[Bob Barrows [MVP]]

You did what? What datatype did you use for the colun\mn? Hopefully not int.

Bob Barrows

 

[Joey Martin]

All is fine. I changed it to decimal and it's working now. Thanks!