Rather than NULL id rather them be blank

Question

0.00/5 (No votes)

See more:

SELECT [Rank]
,[Priority]
,[% Complete]
,[Project Name]
,[Project Manager]
,[Assigned To]
,[Category]
,[Impacted Group(s)]
,[Status]
,[Requested Due Date]
,[Requested By]
,[Project Champion]
,[Created]
,[AVP Team]
FROM [COE_PROJECTS].[19].[COE_PROJ_01_19_2017]
order by 1

What I have tried:

I dont really know what to try. I am quite new to SQL.

Posted 26-Jan-17 9:12am

Member 12969402

Add a Solution

Comments

OriginalGriff 26-Jan-17 15:39pm

This isn't agood question - it doesn't tell us what your problem is, just a trivial bit of SQL.
And why ORDER BY 1 ? That's completely useless as it specifies that all rows have the same sort order!

[no name] 26-Jan-17 15:51pm

http://www.techsupportalert.com/content/how-ask-question-when-you-want-technical-help.htm will show you how to ask a question.

Patrice T 26-Jan-17 16:57pm

Asking questions is a skill[^]

Afzaal Ahmad Zeeshan 26-Jan-17 19:29pm

Leaving something blank is also similar to having NULL (does not exist). In many cases, you can use NULL values to sort the data by passing a WHERE column_name IS NOT NULL and SQL will itself manage the data.

So, in short, keep the data NULL instead of empty.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7870345 · Answer 1 · 2017-01-26T20:53:00

Hello:
I'm not sure of the meaning of your question. But if the question is how to change the output of your query from null to "blank", you can use coalesce function.
Assuming that "project name" is a string and "% complete" is numeric the query will be:

<br />
select [Rank]<br />
,[Priority]<br />
,COALESCE([% Complete],0) AS [% Complete]<br />
,COALESCE([Project Name],'') AS [Project Name]<br />
,[Project Manager]<br />
,[Assigned To]<br />
,[Category]<br />
,[Impacted Group(s)]<br />
,[Status]<br />
,[Requested Due Date]<br />
,[Requested By]<br />
,[Project Champion]<br />
,[Created]<br />
,[AVP Team]<br />
FROM [COE_PROJECTS].[19].[COE_PROJ_01_19_2017]<br />
order by 1<br />