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 bharath1983 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

×

Ad

1 Answer

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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.
NOTE:
The embedded numeric keypad will not function while an external keyboard or numeric keypad.

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

Gary

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.

http://bit.ly/1bUVmuW

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', '[email protected]', 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,


Philip

Nov 05, 2007 | Computers & Internet

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

Related Topics:

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

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

Answer questions

Manuals & User Guides

Loading...