On tenuously related subjects (the use of 'elegant' code, implicit conversions and SARGable queries), one of my favorite bugs is the following code;

SELECT ...

FROM <Table 1> AS a WITH (nolock)...

Matt Miller (#4) (9/11/2014)

---

Not that we need to reopen old wounds, but NULL isn't a value - it's a state representing the lack of a value. Thus it's not...

You have all been really helpful about this... I have had a few attempts at replying and trying to thank people for their input but my writing has been too...

DECLARE @TestVARCHAR(10)

SET @Test = NULL

IF @Test > ''

PRINT '>'

ELSE IF @Test = ''

PRINT '='

ELSE IF @Test < ''

PRINT '<'

ELSE

PRINT 'Bloody NULLs'

I get;

Bloody NULLs

Please don't do this... It's one of the things that drove me crazy with c programmers - the...

Grant Fritchey (9/4/2014)

---

[SQL Prompt] does one heck of a lot more than just formatting. Download it & try it out. You can do that for free. Check out the snippets....

Sadly, at $350 per user, I don't...

I think I have a solution... I'll post it tomorrow.