In MS Sql Server 2008 R2,the Concatenated db fields returns null/blank if one of the concatenated field is null.This is happens in Odbc and Oledb .NET but not in Ado .NET
Version : TD .NET 6.3 SP1 UPD1
MS Sql Server 2008 R2
In Sample, you can see this issues in expanded combo box and grid has all values.
this is normal behaviour in SqlServer because it distinguish null strings (varchar) with empty strings.
You have solve it this way:
select isnull(SomeColumn, '') || isnull(SomeOtherColumn, '') from xyz;
Gupta can confirm on this.
Who is online
Users browsing this forum: [Ccbot] and 0 guests