Absolutely nothing... NOT IN is evaluated to <> for single values and some exclusionary AND's using both for multi-values.

Matt Miller (11/7/2007)

---

...or... (come on Jeff, you KNOW what I am about to say)....

Regular expression CLR functions would do that as well.... But you still need a search string...

brendt hess (11/7/2007)

---

This is one of those cases where COALESCE makes for a fun alternative, because it can make your head hurt figuring out what it is doing. 😉 ...

karthikeyan (11/5/2007)

---

Just Update the Null columns as blank values

Update yourtablename

set add1 = ''

where add1 is null

Now execute your code, it should work

do You know why are you getting 'NULL' Values...

I sure as heck can not figure out how to do that. When I try to copy code into QA when someone used the blocks like I did, it...

Problem is, if you copy from the code block to query analyzer, it really...

I believe that PATINDEX is the only function that will do as you ask on TEXT datatypes.

Heh... and the Oracle notation is backwards from the T-SQL notation... in Oracle (+)= means "Right Outer Join"... in SQL Server, *= means "Left Outer Join". If you believe...

My Questions :

1. Whether the numbers used in this query are constant or not ?

2. Can you explain me the logic of this number ?

3. Can i use any numbers(for...

Yes... for simple queries they will work the same... for not so simple queries with many criteria, *= will surprise...

The answer is, no... Within a given SELECT, Rand is not RAND unless it has a random seed... the only thing in SQL Server that even comes close to being...

jim (11/6/2007)

---

The rightmost bit (if set) of each "group" would be 1...ie 8421

...

Perfect use of "divide and conquer"... nicely done...

I'm glad you brought that up, Ed... using recurrsion to come up with the same or...

??? Recursion has some disadvantages compared to what? And, I'm confused... tell me again why you would use a Factorial function in conjunction with forum messages :blink: