Sql query with default value

Question

I have a select Query in employee table. I need to make sure that column value(empaddress) always pass an empty value in select query:

SELECT 
    empname,
    empaddress,
    empDeptid  
FROM 
    empiD=3

I know that empaddress can contain any value like Null or data. But in the result set it should always be blank

ScottJShea · Accepted Answer · 2013-09-01 10:12:03Z

2

You could do something like this:

SELECT 
    empname,
    "" as empaddress,
    empDeptid   
FROM 
   empiD=3

Unless I am missing something here that would return a blank string in place of the empaddress

answered Sep 1, 2013 at 10:12

ScottJShea

7,12111 gold badges47 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

7alhashmi · Accepted Answer · 2013-09-01 10:17:03Z

2

Try something like this:

SELECT 
    empname,
    null as empaddress,
    empDeptid   
FROM 
    empiD=3;

answered Sep 1, 2013 at 10:17

7alhashmi

9247 silver badges26 bronze badges

1 Comment

ScottJShea Over a year ago

Oh yeah, I did not think of just doing null like that. Might be more performant too

senthilkumar2185 · Accepted Answer · 2013-09-01 15:02:06Z

0

SELECT empname, Isnull(empaddress,'')empaddress, empDeptid FROM empiD=3

answered Sep 1, 2013 at 15:02

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

Comments

halfer · Accepted Answer · 2019-03-16 10:14:32Z

-1

Simply add ISNULL function with '' and it will appear blank:

SELECT 
    empname,
    ISNULL(empaddress,'') AS EmpAddress,
    empDeptid  
FROM 
    empiD=3

edited Mar 16, 2019 at 10:14

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Sep 2, 2013 at 3:16

Simon

4310 bronze badges

Collectives™ on Stack Overflow

Sql query with default value

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related