Numeric expressions against nvarchar(50)

[Neal]

Hello,

I'm developing an application against a database not in my control, I can only query against the structure. A column exists that holds order numbers, but the developers used nvarchar(50) for the column instead of int.

I'd like to use expressions to search for order numbers such as <, >, <=, >= etc. All seems to work fine EXCEPT <. For some reason, this throws an error in my app.

Is it possible to build a SQL query against a nvarchar(50) that treats it like an int, allowing numeric expressions?

 

[Andrew]

Have you tried casting the field as int? For example : CAST(FieldName AS Int)

 

[Mykre]

have a look at the TSQL convert and cast functions in the books online

 

[Neal]

Got it, thanks!

 

[stnkyminky]

Make sure the value you are casting is within the range of values for Sql's int datatype.