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 |
|
toxicrainpx
Starting Member
8 Posts |
 Posted - 2008-12-24 : 06:48:38
|
| Hello, I have a field with 50 Chars and I want to Cut the field on the 15th Char. How can I do this. Thanks in advance. |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-12-24 : 06:55:33
|
quote:
Originally posted by toxicrainpx
Hello, I have a field with 50 Chars and I want to Cut the field on the 15th Char. How can I do this. Thanks in advance.
use LEFT function like this, select left(columnname,15) |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-24 : 06:58:19
|
| select substring(urcolumnname,1,15) |
|
|
|
|
|
|
Truncating Field