.NET Returns blank if one db field is blank in concatenation

[a_sivababu]

Hello Support ,

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
[img]

NullCombo.png

[/img]

In Sample, you can see this issues in expanded combo box and grid has all values.

Thanks!

Siva A

[frevelundfey]

Hi Siva,
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;

Regards Thomas

[a_sivababu]

Thanks Thomas for the workaround. we have also done the same thing but my doubt is that, it works in win32 and also for ado.NET. So I thought there is a issues in Gupta database API for Odbc.NET and Oledb.NET.

Gupta can confirm on this.

Thanks!
Siva A