Question about Microsoft SQL Server Standard Edition for PC
Hi, How to get only the numeric part of a database feild of varchar type. Thanks in advance. Regards, Bharath K R
Well, one solution is to fetch the whole data, including the non-numeric part, and then convert that into a number. Most programming languages strips off the non-numeric part of a string when converting into a number. For example, converting '24Michell' to a number will result into '24'. Consult your programming manual on how to convert a string into a number.
Posted on Oct 01, 2007
Tips for a great answer:
Apr 05, 2016 | HP EliteBook 2530p Notebook
Apr 30, 2014 | Kyocera Copystar CS-1635 Copier
Nov 25, 2013 | Computers & Internet
Sep 06, 2013 | Sun MySQL
Jun 18, 2009 | Computers & Internet
Mar 22, 2009 | HP 2133 Notebook PC
Nov 05, 2007 | Computers & Internet
102 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: