Sue
Member since Jun 10, 2010
- Profile: /members/6178-sue.htm
- Comments: 2
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 »