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 |
|
simi28
Starting Member
27 Posts |
 Posted - 2007-05-18 : 06:11:01
|
| Hi alli want to remove text from my column name using query.for example i have the product name like "silver 8' trampoline pack "i need to remove "silver 8' " and want to display only trampoline packsimilarly if I have product name like "gold 8' trampoline pack"i need to display only trampoline pack.can anybody help me in this regard?thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-05-18 : 06:14:58
|
what is the rule ? How do you decide what to remove what you retain ?Check out the books online on string function like replace(), stuff() etc
KH |
 |
|
|
simi28
Starting Member
27 Posts |
Posted - 2007-05-18 : 06:34:34
|
| thanks for ur reply.I have got so many functions but I need to know how can I remove the characters when it is not fixed.it may be silver 8' from silver 8' trampoline pack or may be gold 10' from gold 10' trampoline delux pack.i want to know how can fixed the length to remove |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-05-18 : 06:36:12
|
is it anything before the single quote ?you can use charindex to find the location of the single quote
KH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-18 : 06:36:30
|
| Also read about charindexMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-18 : 06:38:19
|
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
removing text from column name