johnhectar (4/1/2010)

---

how can v insert parameters into procedure

Alvin Ramard (4/1/2010)

---

FYI, here's the suggestion I had sent to Steve for today's QOD:

<snip>

What's the correct answer?

Steve Jones - Editor (4/1/2010)

---

NULLs HAVE been deprecated, haven't you heard. SQL 11 will have no NULLs

The Dixie Flatline (4/1/2010)

---

You've been going without sleep... haven't you?

John Rowan (4/1/2010)

---

Man Man (my 3 year old's way of saying batman)

Chris Morris-439714 (4/1/2010)

---

Oh doen't!

David-155102 (4/1/2010)

---

The previous version of the procedure would create the WHERE clause based upon whether any of the parameters were not NULL

vaibhav.tiwari (4/1/2010)

---

One more thing some date is like '25-01-2010 09:51:59' that is the valid date but can not be converted into date.

The Dixie Flatline (4/1/2010)

---

Paul, I'm curious. I understand right-padding the high value with char(255) to simulate a wildcard, but why add CHAR(1) to the low value?

The Dixie Flatline (4/1/2010)

---

Actually, I like this approach. The only thing I would suggest is to tweak it to accept character strings with a length greater than 1.