I want to include two columns in the VS dataset-designer's Table Adapter Wizard. The problem is that there are null values in a column and therefore compilation results in spaces, regardless of the value of the other columns. I've found that I want, which is a database option. How can I change this setting in TableAdapter Query Builder? Is there any alternative?
OK, I have solved it in the following way:
TabSparePart.SparePartName + '' + ISNULL (tabSparePart.SparePartDescription, '') AS LongSparePartName 
Comments
Post a Comment