NULL value in results - Level Extreme

From

13/06/2008 11:41:35

To

13/06/2008 11:38:34

Jay Johengen
Altamahaw-Ossipee, North Carolina, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01323872

Message ID:

01323874

Views:

19

>Select:
>
>

>	QUOTENAME (ISNULL(InsCompanyID2,''),'"') AS InsCompanyID2,
>

>
>The result for this column is NULL, I need it to be "".

Use another SQL Server function ISNULL or COALESCE.

If it's not broken, fix it until it is.

My Blog