View previous topic :: View next topic
|
Author |
Message |
PRV
New User
Joined: 16 Apr 2009 Posts: 15 Location: Pune
|
|
|
|
I have one task which needs the conversion of alphanumeric field into numeric .
Can we convert alphanumeric field into numeric type field ? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
a) What product are you using#
b) What happened when you tried it |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
if a field has been defined as alphanumeric ,
and the content is alphanumeric
Your approach will just lead to trouble,
whatever language, database, dataset organization, operating system, user program, utility, ..., ..., ...
You would be using |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Can we convert alphanumeric field into numeric type field |
Only if the alphanumeric field will always contain only a valid numeric value. Anything other than a valid numeric will most likely cause an abend at some point (unless the data is programmatically validated before conversion/use). |
|
Back to top |
|
|
|