Converting a string to a decimal point

[fergy1]

Hello-

I have an acreage field that has decimals and some with null values. How can i create a search between a value and value without it displaying incorrectly? For example i do a search between .5 acres and 1 acres I dont want 10 acres showing up as well as it does now.

So I have this now which does not work right:

Select * from table where Acreage BETWEEN '.5' and '1'

 

[jbenson001]

What datatype are you using to store Acreage? I just tried your example using a varchar column and it worked fine.

Jim