|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Code Help
I am trying to figure out how to remove the ‘400’ from in front of a number, for example ‘40012345678’, I just want ‘12345678’. The table I have contains about 5000 row and all of the number start with ‘400’. I do not know what sql to use. Can someone give me some help?
|
|
#2
|
|||
|
|||
|
use either the Right or Mid Functions
S- |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Code Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|