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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-09-02 : 15:29:47
|
| I have the following data in one of the department field in a table: {\rtf1\ansi\...\deflang1033{\fonttbl{\f0\fnil\fcharset0 Microsoft Sans Serif;}} \viewkind4\fs17 Electronics Department\par \par } How do I get just the "Electronics Department" value from the above column, please advice.Thanks!! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-02 : 18:04:31
|
| Read up on substring in books online |
 |
|
|
|
|
|
Remove invalid data from a column