Member Login:
e-mail:
password:
Register
Forgot Password
Site FAQ
Home
>
IT Answers
>
Development
> Alpha to numeric
Buzzy
5 pts.
Alpha to numeric
Development
,
Programming
,
Query
How to converet a field from alpha to numeric in query
Software/Hardware used:
ASKED:
October 10, 2008 2:34 PM
UPDATED:
October 10, 2008 10:25 PM
Discuss
 
Add to Watchlist
RELATED QUESTIONS
Crystal Reports 11 problem with excel spreadsheet
Convert and Expand Field through SQL/400
Saving production libraries on AS/400 - Best practices
How to identify whether the field values are in particular format
AS400 menu options help creation
Answer Wiki:
Are you talking about SQL query? You can use a scalar function to do that: SELECT INTEGER(column) FROM table or SELECT DECIMAL(column) FROM table
Are you talking about SQL query? You can use a scalar function to do that: SELECT INTEGER(column) FROM table or SELECT DECIMAL(column) FROM table
Last Wiki Answer Submitted:
October 10, 2008 2:44 pm
by
RodneyKrick
265 pts.
All Answer Wiki Contributors:
RodneyKrick
265 pts.
To see all answers submitted to the Answer Wiki:
View Answer History
.
Please complete the following information:
REGISTER / LOG-IN TO ANSWER QUESTION
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
RSS - Discussions
Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Please complete the following information:
REGISTER / LOG-IN TO DISCUSS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
POSTED:
Oct 10, 2008 10:25 PM (GMT)
Using what platform?
Denny Cherry
64,520 pts.
Ask a Question
Question Title:
(150 char. limit.)
Question:
(Please be specific.)
Tags:
(Separate each tag with a comma.)
What is a Tag?
Browse IT Answers by Topic
AS/400
Big Data
Business Intelligence
Channel
CIO
Cloud Computing
Consumerization
CRM
Database
DataCenter
Development
Exchange
Linux
Lotus Domino
Microsoft Windows
Mobile
Networking
Oracle
SAP
Security
SQL Server
Storage
Virtualization
VoIP
Windows Server
>>
VIEW ALL TAGS
Using what platform?