Need Help with select

[Dave Brown]

Hi all

I have a DataTable containing all String datatypes.
I need to query the table for records where one of the fields numeric value
is between two other numeric values.

I've been trying the following
string val1 = '1';
string val2 = '2';

filt = "Field1 between '"+val1+"' and '" + val2 + "'"

i dont understand how to differentiate between string and numeric values in
a select, so any help apprecitiated.

rgds,

Dave.

 

[Miha Markic [MVP C#]]

Hi Dave,

Try using
"Convert(Field1, 'System.Int32') >= " + val1 + " and Convert(Field1,
'System.Int32') <= " + val2;

 

[Dave Brown]

thanks

Hi Dave,

Try using
"Convert(Field1, 'System.Int32') >= " + val1 + " and Convert(Field1,
'System.Int32') <= " + val2;

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Hi all

I have a DataTable containing all String datatypes.
I need to query the table for records where one of the fields numeric value
is between two other numeric values.

I've been trying the following
string val1 = '1';
string val2 = '2';

filt = "Field1 between '"+val1+"' and '" + val2 + "'"

i dont understand how to differentiate between string and numeric values in
a select, so any help apprecitiated.

rgds,

Dave.