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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-05 : 00:57:41
|
Joel writes "This is probably a simple question but I will ask anyways. How do you strip away certain characters from text without affecting the rest of the text. I have a database that contains book titles. I would like to strip away all the "A, An, The" from the titles of the book but do not want to removing it any where else in the field (example The History of Theater and the Met! A study" I would like just the opening "the" removed but not the middle one)
The datatype is nvarchar
thanks" |
|
|
|
|
|
Stripping away opening characters