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 |
|
mufasa
Yak Posting Veteran
62 Posts |
 Posted - 2003-09-11 : 14:56:01
|
I have a question on formattingI am migrating a lot of my work from Access to SQLI need to extact only the middle of a field in a view, but Mid does not seem to work.Can anyone tell me how you can extract only the middle of a field?In MS Access it would be Format(Mid([field],6,30)ThanksMufasa  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 14:56:46
|
| Take a look at the SUBSTRING function in SQL Server Books Online.Tara |
 |
|
|
|
|
|
Simple Formatting Question