• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Help with delete statement

I have a varchar field that can contains values like

ABC
01235
CD2451

I like to delete everything that has only numbers. How can I do that?
0
hulken
Asked:
hulken
  • 4
  • 3
  • 2
1 Solution
 
Atlanta_MikeCommented:
WHERE ISNUMERIC(field) = 1
0
 
SireesCommented:
you can use isnumeric(field)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Atlanta_MikeCommented:
?
0
 
hulkenAuthor Commented:
Sorry Atlanta Mike. I missed that your answer was first. I will add a new Questions named Points for Atlanta_Mike
0
 
Atlanta_MikeCommented:
Thanks... thought that was funny.
0
 
hulkenAuthor Commented:
If i didnt have missed  your message I would have saved 30 sec to find out that I have to use = 1
0
 
hulkenAuthor Commented:
0
 
Atlanta_MikeCommented:
Cool. :-)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now