Oh, well if you look at it in the actual list you can...

The question was in the title.

Matt Miller (2/26/2008)

---

What happens to make it "not work"? Looks to me that it's valid, although it looks like it should be rewritten as

select Substring(J.MAP_NUM, 1, 4) as...

I get an "Internal SQL Error".

Thank you

Thanks for your help.

Thanks. The above actually worked for me when I removed the a. Can you not set aliases like that in an update?

UPDATE CIS_IVR_Master_200712100600

SET CIS_IVR_Master_200712100600.BI_SSN = (SELECT b.BI_SSN FROM CIS_IVR_Master_200712080600...

Thanks alot.

Hmmm....sounds like I need a processor license. That sucks, that's alot of money for not alot of database usage.

Thanks for the help guys!

Ah nm I got it. Kind of silly that the default properties of trim string is not to trim anything.

Thanks guys, I did it John's way, with the added Order By Aaron suggested, and I changed this one line;

SET Blanks = g1.AccNo - g2.AccNo - 1

March 19, 2007 at 11:26 am

#695776