Please help me in ado.net

[abglorie]

How to using val() in sql? mycode datatype is string values as "MS12", "MW10", ... My query is "Select * from FILE1 where val(substring(mycode,3,2))=10" Sql say error as val is not recognised function name Kindly tell your suggesions. Thanking you abglorie

[Abhishek Sur]

which database you are working? Please specify

Abhishek Sur

[abglorie]

sql2000 database is using

[Ashfield]

abglorie wrote:

Sql say error as val is not recognised function name

Thats because it isn't. Bet you copied this from excel or Access. Just look up substring in sql help.

Bob Ashfield Consultants Ltd

[Abhishek Sur]

write like this Select * from FILE1 where Cast(substring(mycode,3,2) as int)=10

Abhishek Sur