CASE Question

[load3d]

What would be the proper syntax for this? I want to use openquery to open another query if the value is null. Is it possible to do that? I'm using SQL server 2005


EXAMPLE:

CASE WHEN (COLUMNNAME)ISNULL THEN Openquery(Servername 'Select TOP 1 from dbo.db.column inner join on columname) else 'DEFAULT JOB FUNCTION' END

 

[markros]

case when ColumnName IS NULL then ... ELSE 'DEFAULT JOB FUNCTION' END

 

[load3d]

let me rephrase.... is it possible to select a value from a different query in case statement using the openquery function? I tried to do it... but I'm not sure if it's possible.