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.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2010-07-22 : 15:21:33
|
| in this code, what does the ' ' and the isnull do? someone added this to the SQL which was crashing the first pass in the Silverlight.SELECT LTRIM(RTRIM(ISNULL(d.DepartmentName, ''))) AS Department ,ISNULL(t.Cost, 0) AS Expense ,ISNULL(t.Quantity , 0)AS Quantity ,LTRIM(RTRIM(ISNULL(c.CustomerName, ''))) AS CUSTNAME ,LTRIM(RTRIM(ISNULL(i.ItemName, ''))) AS Description |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-22 : 15:45:16
|
it is just replacing a NULL value by an empty string.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
what does this ' ' do