Code Project

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Please help me in sql server

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
abglorie

wrote on last edited by

#1

I am working in SQL Server/asp.net Database 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
S 1 Reply Last reply

0
A abglorie

I am working in SQL Server/asp.net Database 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
S Offline
S Offline
sumit7034

wrote on last edited by

#2

Re: Please Dont Cross Post:mad:
1 Reply Last reply

0

Log in to reply