Sue

Recent Blog Comments By Sue

• SQL Date/Time BETWEEN And Comparison Operators Work With Floats

  Posted on Jun 16, 2010 at 10:56 PM

  Thanks for your respond. I've figured out the solution. isnull(CAST(CONVERT(varchar(11), a.icSUBDATE, 106)AS varchar(11)),'-') as SubmitDocToInsCo it will return a dash '-' if the date is NULL.. Cheers!... read more »

• SQL Date/Time BETWEEN And Comparison Operators Work With Floats

  Posted on Jun 10, 2010 at 5:47 AM

  Hi.. isnull(somedate,0) would return "1900-01-01 00:00:00.000" for null.. my Q is.. how to return "-" instead? I'm a newbie.. how do i change it to String?... read more »