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 |
|
David Lopez
Starting Member
19 Posts |
 Posted - 2005-06-30 : 07:24:23
|
| Is there a way you can extract an amount of characters from a VARCHAR?I have a column which has always the same amount of numbers, and I want to extract from it the data in 4 parts (first 4 numbers, next 4 number, next 2 numbers and the last 20 numbers)I remember that there was something with String and Length, but as I havn´t done SQL for lamost 5 years and help is welcome to push me in the right directionDavid |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-30 : 07:37:45
|
| Look for Substring in BOLMadhivananFailing to plan is Planning to fail |
 |
|
|
David Lopez
Starting Member
19 Posts |
Posted - 2005-06-30 : 07:47:59
|
| Thx |
|
|
|
|
|
|
Returning a part of a string