Return a value with space 1

[AgentM]

I am new to t-SQL and was looking for some help.

Is there a way to display a "space" or Null value in a column when no data is returned for a query.

E.g. If I run the query below
SELECT EMPNAME, EMPMIDDLE Where EMPName='bob'

When I run this query and if there is no Empname as 'bob' then at least one row should be returned. With "bob" in the EMPName columen and "Null" in the EmpMiddle column.

how can I do that in a SELECt Statement

Hope that helps.
thank you for your help

 

[bborissov]

IF EXISTS(SELECT EMPNAME, EMPMIDDLE Where EMPName='bob')
   SELECT EMPNAME, EMPMIDDLE Where EMPName='bob'
ELSE
   SELECT 'bob' AS EMPNAME, CAST(NULL as (type of EMPMIDDLE here) AS EMPMIDDLE

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

Hey, in your first statements (both of them) you forgot FROM clause

IF EXISTS(SELECT 1 from myTable Where EMPName='bob')
   SELECT EMPNAME, EMPMIDDLE from myTable Where EMPName='bob'
ELSE
   SELECT 'bob' AS EMPNAME, CAST(NULL as (type of EMPMIDDLE here) AS EMPMIDDLE

 

[bborissov]

Copy and Paste problem

That is because AgentM posted the SELECT statement w/o FROM and I even didn't notice this

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.