More Group Sites
School Rankings
Jobless Net
Better Home
Enviro++

Help | Subscribe/Unsubscribe | Rules | Other Group Sites: Better Education | Better Education Forum
Welcome Guest Search | Active Topics | Members | Log In | Register

Developer Forum » Software Engineering and Information Technology » Database Programming » Use COALESCE instead of ISNULL or NULLIF in SQL Server CE 3.5

Use COALESCE instead of ISNULL or NULLIF in SQL Server CE 3.5 Options · View
Previous Topic · Next Topic
hong
Posted: Thursday, February 24, 2011 8:53:46 PM

Rank: Administration
Groups: Administration

Joined: 11/23/2008
Posts: 335
Points: 711
Location: Australia
ISNULL and NULLIF are not supported in SQL Server CE 3.5, use COALESCE instead.

Code:
SELECT COALESCE(USER_CUSTOM_NAME, '') + ' ' + COALESCE(USER_FIRSTNAME, '') + ' ' + COALESCE(USER_LASTNAME, '') + ' (' + USER_SYSTEM_NAME + ')' FROM USERS


With multiple arguments, COALESCE returns the first non-null expression among its arguments. For example,

Code:
SELECT COALESCE(USER_CUSTOM_NAME, USER_FIRSTNAME, USER_LASTNAME, '') + ' (' + USER_SYSTEM_NAME + ')' FROM USERS
Back to top
 
Sponsor
Posted: Thursday, February 24, 2011 8:53:46 PM
Back to top
 
Users browsing this topic
Guest

Developer Forum » Software Engineering and Information Technology » Database Programming » Use COALESCE instead of ISNULL or NULLIF in SQL Server CE 3.5


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

ASPNET Theme created by Boskone (Dan Ferguson)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.168 seconds.