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:

Ah... got it. Thanks...

You bet... thanks for the feedback. Gotta love those "3rd party vendors". 😛 Only reason I knew how to do this is because I had to fix one...

winston Smith (11/6/2007)

---

this seems to work, however id like to know why my join didnt work. it just kept running and running until i killed it after 8 minutes. anyone...