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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-02-18 : 22:19:40
|
| How i can delete text from file here is sample data121can122dela23How i can delete (can)& (del)& (a) from source file. Thanks for your help. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-02-18 : 22:40:59
|
[code]delete yourtablewhere isnumeric(col) = 0[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-02-18 : 23:31:08
|
| I really appreciate your prompt reply, Its solve my problem, Just for curiosity how i can delete only (a) from a23 in sql, here is examplea23345g56 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-21 : 03:29:39
|
quote:
Originally posted by khtan
delete yourtablewhere isnumeric(col) = 0
KH[spoiler]Time is always against us[/spoiler]
Isnumeric() is not fully reliableselect isnumeric('12d3')MadhivananFailing to plan is Planning to fail |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-21 : 04:59:31
|
Check if this works for you  delete from tableName where ColName like '%^[0-9]%'CheersMIK |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
T-SQL