Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULL value in results
Message
From
13/06/2008 11:41:35
Naomi Nosonovsky
Wisconsin, United States
 
 
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:
Re: NULL value in results
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323872
Message ID:
01323874
Views:
15
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform