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 |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2011-09-19 : 15:51:03
|
| Can someone, please, please help me here; I am very, very confused.I am grabbing ssn values from an oracle database with this query:SELECT substr(SSN,6)FROM MYTABLEand I am getting the correct value of 1111When I insert that value into a a sql server table, I am getting a different value.For instance, let's assume that the ssn that I am grabbing is 123456789, in Oracle, I get 6789 which is correct.However, after inserting the value a sql server db asInsert into mytable (ssn) values(ssn), the value shows as 5678.I also tried selecting the entire ssn as SELECT substr(SSN)FROM MYTABLE and then try inserting into a sql server db as:Insert into mytable (ssn) values(right(ssn,4).I still end up with 5678.Can anyone, please tell me what I am doing wrong?Thanks a lot in advance |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2011-09-19 : 16:36:17
|
| never mind, I got it. |
 |
|
|
|
|
|
last 4 digits of ssn