Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
8 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sql Isnull()
Posted on 2012-12-23
I have the following Select statement:
select CustomerID, Name,
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),(ISNU
END as BuyDate
from Customers;
BuyDate --it's datetime field in the Customers table
ISNULLL(BuyDate, '') returns 01-01-1900 if BuyDate contains NULL.
Is there BETTER WAY to re-write the below piece of my sql sttement ???
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),(ISNU
END as BuyDate
Thanks
select CustomerID, Name,
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),(ISNU
END as BuyDate
from Customers;
BuyDate --it's datetime field in the Customers table
ISNULLL(BuyDate, '') returns 01-01-1900 if BuyDate contains NULL.
Is there BETTER WAY to re-write the below piece of my sql sttement ???
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),(ISNU
END as BuyDate
Thanks
[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
5 Comments
Active today
not sure if it's much better but at least a bit shorter:
CASE
WHEN BuyDate IS NULL THEN (' ')
ELSE (CONVERT(varchar(10), BuyDate, 110))
END as BuyDate
try this also
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),BuyDa
END as BuyDate
CASE
WHEN (CONVERT(varchar(10),(ISNU
ELSE (CONVERT(varchar(10),BuyDa
END as BuyDate
Hi,
This seems much simpler, in case you don't need the null date in string format:
select EmployeeID, FirstName, ISNULL(BuyDate, NULL)
from Customers;
Let me know if anything.
Regards,
Igor
This seems much simpler, in case you don't need the null date in string format:
select EmployeeID, FirstName, ISNULL(BuyDate, NULL)
from Customers;
Let me know if anything.
Regards,
Igor
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
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.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
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:
…
Suggested Courses
Course of the Month8 days, left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.