Help with COALSCE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help with COALSCE

Author

Topic

Pinto
Aged Yak Warrior

590 Posts

Posted - 2008-05-13 : 06:30:18

I am trying to use COALESC in this statement and am getting syntax errors

Dim PropFullAdd As String = "Property Add : " + COALESCE(Me.Reg_PropAdd1TextBox.Text,"N/A") + ", " + COALESCE(Me.Reg_PropAdd2TextBox.Text,"") + ", " + COALESCE(Me.Reg_PropAdd3TextBox.Text,"") + ", " + COALESCE(Me.Reg_PropAdd4TextBox.Text,"") + ", " + COALSECE(Me.Reg_PropPcodeTextBox.Text,"")

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-05-13 : 06:33:36

Coalesce() is SQL Server specific function. It seems that you are using it inside your VB code.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"