>From Clients

Jim in Arizona wrote:
> I'm working on an ASP.NET project and when a query is ran, some rows
> returned are NULL, which is causing my app to break. The data is pulled
> into my webpage as a string, which I'm converting to Int32 to do a
> number comparison for page formatting purposes. If the value is NULL,
> then the NULL value cannot be converted to Int32, which causes the app
> to break.
>
> Here is the SQL statement that is being ran:
> ==================================================
> SELECT
> m.[Client ID]
> ,CONVERT(varchar(10),t.[Date],101) AS [Date]
> ,Putime = convert(varchar(8), t.Putime, 108)
> ,Apptime = convert(varchar(8), t.Apptime, 108)
> ,Dotime = convert(varchar(8), t.Dotime, 108)
> ,Rputime = convert(varchar(8), t.Rputime, 108)
> ,Rdotime = convert(varchar(8), t.Rdotime, 108)
> ,Apptimeout = convert(varchar(8), t.Apptimeout, 108)
> ,datediff(minute, t.Putime, t.Apptime) AS 'PU to Appt'
> ,datediff(minute, t.Dotime, t.Apptime) AS 'DO to Appt'
> ,datediff(minute, t.Apptimeout, t.Rputime) as 'Appt to RPU'
> ,datediff(minute, t.Apptimeout, t.Rdotime) as 'Appt to RDO'
> FROM [T-Client Master] m
> INNER JOIN [T-CMDB] t
> ON m.[Client ID] = t.[Client ID]
> WHERE t.Date = convert(datetime, @dt, 101)
> ==================================================
>
> The datediff are the the ones that are returning NULL values among the
> non null values. Is there a way to convert any NULL values into in blank
> string (ie. '') or 0 Integer or something other than null?
>
> The specific ones I need to place non null values in are:
>
> ,datediff(minute, t.Dotime, t.Apptime) AS 'DO to Appt'
> ,datediff(minute, t.Apptimeout, t.Rputime) as 'Appt to RPU'
>
> TIA,
> Jim