Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.
COURSE of the MONTH
9 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to exclue numeric data from the select?
Posted on 2011-03-14
There are some errornous data entered in form of 4-digit year. How can I exclude inserting these? Thanks.
INSERT INTO [DegreeMajor]
([Major Title])
select distinct ltrim(rtrim(degree_Major))
where degree_Major is not null and degree_Major not in ('MD', 'Master', 'B.A.', 'M.D.', '.', '', 'Doctor', 'MSC')
INSERT INTO [DegreeMajor]
([Major Title])
select distinct ltrim(rtrim(degree_Major))
where degree_Major is not null and degree_Major not in ('MD', 'Master', 'B.A.', 'M.D.', '.', '', 'Doctor', 'MSC')
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
- +1
7 Comments
Try ISNUMERIC for SQL:
select distinct ltrim(rtrim(degree_Major))
where degree_Major is not null and ISNUMERIC(degree_Major)=1
select distinct ltrim(rtrim(degree_Major))
where degree_Major is not null and ISNUMERIC(degree_Major)=1
Active today
select distinct ltrim(rtrim(degree_Major))
from dbo.PersonDegree pd
where ISNUMERIC(degree_Major)=1
is enough...
from dbo.PersonDegree pd
where ISNUMERIC(degree_Major)=1
is enough...
Featured Post
At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month9 days, 23 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.