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:
Usually answered in minutes!
Step 2: Please assign your manual to a product: