I have a phonenumber field and I want to get the last five digits, so I am using the following
right(phonenumber,5)
This works on most of my tables except one, where I get the following
00000
01
02
03
04
0100
etc
Anyone know what this is all about and why I am getting this instead of 5 digits. I do have phonenumber set as primary key in this table but I cannot see any other differences. I took the primary key off and the same thing happened
The phonenumber field in all tables is nvarchar(25)
Can any one help???
right(phonenumber,5)
This works on most of my tables except one, where I get the following
00000
01
02
03
04
0100
etc
Anyone know what this is all about and why I am getting this instead of 5 digits. I do have phonenumber set as primary key in this table but I cannot see any other differences. I took the primary key off and the same thing happened
The phonenumber field in all tables is nvarchar(25)
Can any one help???