Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
In this article I will describe the Copy Database Wizard 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
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…
Suggested Courses
Course of the Month9 days, 16 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.