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
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
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
Oct 17, 2017 | Microsoft SQL Server Standard Edition for...
94 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: