Conditionally select and format one of two columns

[PeDa]

In SQL Server 2005 R2, I want to select:
IF column_1 IS NULL THEN MyUserDefinedFunction_2(column_2) ELSE MyUserDefinedFunction_1(column_1)
Any suggestions on how to achieve this would be greatly appreciated.

 

[imex]

Try:

select 
    CASE WHEN column_1 IS NULL 
        THEN MyUserDefinedFunction_2(column_2) 
        ELSE MyUserDefinedFunction_1(column_1)
    END,

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[gmmastros]

There are several types of user defined functions based on the data they return. If both functions are "Scalar Valued Functions", then you should be able to do this:

Select  ColumnA,
        ColumnB,
        Case When Column_1 Is NULL
             Then dbo.MyUserDefinedFunction_2(column_2)
             Else dbo.MyUserDefinedFunction_1(column_1)
             End As ColumnNameAlias
From    YourTableNameHere

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[PeDa]

Thank you both. This does indeed work:

SELECT 
    CASE WHEN dbo.tbArcStudies.gStudienr IS NULL 
        THEN 'p'+dbo.udf_FormatProjectNumber(dbo.tbArcStudies.gProjnr) 
        ELSE dbo.udf_FormatStudyNumber(dbo.tbArcStudies.gStudienr)
    END
FROM dbo.tbArcStudies

Peter D.