Question about Microsoft SQL Server Standard Edition for PC

1 Answer

Selecting only Numeric part of a database feild

Hi, How to get only the numeric part of a database feild of varchar type. Thanks in advance. Regards, Bharath K R

Posted by on

  • bharath1983 Oct 04, 2007

    Hi Beakman,

    Thanks for all your help.

    I solved this problem using the left() and right() as the database field was of fixed lenght, that is available SQL server 2005.

    Thanks once again.

    - Bharath K R



1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

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


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How can i lock the keypad?

Hi Eliza,
Enabling and disabling the embedded numeric keypad
Press fn+num lock to enable the embedded numeric keypad. Press fn+num lock again to return to standard keyboard functions.
The embedded numeric keypad will not function while an external keyboard or numeric keypad.

Thanks Hope this helps!
Don't forget to rate:)


Apr 05, 2016 | HP EliteBook 2530p Notebook

1 Answer

Maintenance light blinks

Enter "10871087" using
the numeric keys
Enter the U251 number using numeric keys.
Press the copy start key.
Select the Light exp. 3. using the exposure adjustment keys.
Press the copy start key.
The count is cleared, and the indication for selecting a maintenance item No. appears.

Apr 30, 2014 | Kyocera Copystar CS-1635 Copier

1 Answer

Having troube with my FOREIGN KEYs on two tables.

I suggest you visit this website you will get the solution, I tried and it worked.

Nov 25, 2013 | Computers & Internet

1 Answer

Mysql> desc contact_info -> ; --------------

Hi David,

It looks like you're missing two more null's in the third record, the column count is only 21 and you have 23 fields in your destination table.

All your data matches up to the columns, but you'll need to insert ", null, null" before the last paren to cover CompanyURL and companyPhone):

('Karson', 'B', 'Campbell', null, 'Dr.', 'Chief Resident', 'Pediatrics', '', null, null, '585-544-1212', 'home', '1955-01-05', 'Wife: Molly Kids: Cassidy, Justine, and Cory.', 'Mountain View Hospital', null, null, null, null, null, null, null, null, null, null )

Sep 06, 2013 | Sun MySQL

1 Answer

Numeric keypad does not respond.

make sure that the num lock is on. There are 5 indicator lights on the left side of the power button, the first indicator on the left is Num Lock, make sure this is lit up.

Mar 30, 2010 | Dell Inspiron 6000 Notebook

1 Answer

Numeric Keypad doesn't work after windows XP logon

pause your antivirus and plug ur keyboard pin

Jun 18, 2009 | Computers & Internet

5 Answers

Keyboard letters 'm,j,k,l,u,i,o' permanantly locked for numerals. i have no idea how i switched this function on.

NumLock is on. Look for the Fn key in the lower left corner, and lookint in the top right, the NumLock key.

Mar 22, 2009 | HP 2133 Notebook PC

1 Answer

Numeric keypad stopped working.

Press Num Lock above numeric 7 and see if the Led of your keyboard turn on. Hope it help.

Mar 17, 2009 | Computers & Internet

1 Answer

Find the Price for cabinet door

If you dos program can support Structured Query Languange (SQL) that's possible to do it. example sql statement below:

SELECT * from Cabinet WHERE height='numeric' AND width='numeric' ORDER BY Height, Width

But since it doesn't work with your existing programming language, much better if you will migrate to GUI programming language such as Visual Basic, Visual C++.

Hoping for your kind approval to make my rate solved.

Best regards,


Nov 05, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides