Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jto
Starting Member
3 Posts |
 Posted - 2007-12-05 : 08:15:42
|
| i want to import/copy a varchar field numeric data in to number field pls suggest the solution one thing more can i convert field type of a table how?jto it |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-05 : 08:17:41
|
You could use SELECT Col1 FROM Table1 WHERE ISNUMERIC(Col1) = 0to see which records that SQL Server will not be able to transform for you on the fly when inserting.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jto
Starting Member
3 Posts |
Posted - 2007-12-05 : 08:46:36
|
| thanks for the reply i ran this query for oracle table and i am getting isnumeric invalid identifier pls suggest the solutionjto it |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-05 : 08:48:30
|
You missed the fact that this is a MICROSOFT SQL SERVER forum?Try post your question at www.dbforums.com
E 12°55'05.25"N 56°04'39.16" |
|
|
|
jto
Starting Member
3 Posts |
Posted - 2007-12-05 : 09:00:30
|
| ok i will try on db forumsjto it |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-06 : 01:51:06
|
| http://www.techonthenet.com/oracle/questions/isnumeric.phpMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
importing of varchar field data in number field