By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

i could not execute update comd

P: 1
Expand|Select|Wrap|Line Numbers
  1. update tbl_ApplicantInfo set PinNo=substring(pinno,2,10)
hear pinno is numeric, for this reason this comd is not execute
Sep 23 '14 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,430
Convert the string to a number using the cast or convert function.
Sep 23 '14 #2

Frinavale
Expert Mod 5K+
P: 9,731
Just in case you don't know about the convert or cast functions check out this article about Cast and Convert in SQL.

-Frinny
Oct 2 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.