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 |
|
Chris_Kelley
Posting Yak Master
114 Posts |
 Posted - 2014-09-18 : 09:44:26
|
| c |
|
|
Chris_Kelley
Posting Yak Master
114 Posts |
Posted - 2014-09-18 : 09:46:02
|
| c |
 |
|
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2014-09-18 : 14:45:04
|
| Two methods:1) select issueraccountnumber%1000000000 from db2) select right(cast(issueraccountnumber as varchar(max),9) from db |
|
|
|
Upendra Gupta
Starting Member
12 Posts |
Posted - 2014-09-19 : 06:26:43
|
| unspammed |
|
|
|
|
|
|
LEFT?