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 |
|
dbonneau
Yak Posting Veteran
50 Posts |
 Posted - 2009-03-06 : 11:52:48
|
| Name Date TimeF.FF.YYAE09 2009-03-03 15:00 F.FF.YYAE09 2009-03-03 15:00 F.FF.YYAE09 2009-03-03 15:00 F.FF.YYAE09 2009-03-03 15:00 F.FF.YYAE09 2009-03-03 15:00 F.FF.YYA 2009-03-05 15:59F.FF.YYA 2009-03-05 15:59F.FF.YYA 2009-03-05 15:59F.FF.YYA 2009-03-05 15:59F.FF.YYA 2009-03-05 16:00F.FF.YYA 2009-03-05 16:00Hi I have a table that has two different values in one field. Please refer to name field.I would like to take out "E09" so I can have only one uniform value as "F.FF.YYA" in name field.could you please help me to alter this ?Thanks |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-03-06 : 12:15:31
|
| try thisupdate yourtableset name = substring(name,1,len(name)-3)where name like '%E09' |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-06 : 12:19:37
|
| Or this..update urtable set Name = replace(Name,'E09','') |
|
|
|
dbonneau
Yak Posting Veteran
50 Posts |
Posted - 2009-03-06 : 12:23:41
|
| It works fine! Thank you so much guys ! |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-03-06 : 23:45:40
|
| Welcome..... |
|
|
|
|
|
|
alter string