Bill - the #s are summed based on course_level of "cert" or "diploma"..

the formula is not adding/subtracting letters but the #s in the columns associated with them..however, I still don't...

Prakash - here's another poster who seems to be attempting something identical..maybe you could read up on the documentation link posted on that thread...

sysobjects.category

here's a replace I tested in QA 2000 - works fine..

declare @str varchar(10)
declare @position tinyint
set @position = 1
set @str = 'hu' + char(13) + 'll' + char(10) + 'o'
set...

well - "status" is reserved for internal use by SQL Server - in my master db all the status values are -214######, -107##### etc. for the objects...so you may want...

You could add a conditional update like this...

....
b.mem_type = case 
when (b.mem_type is null) or (b.mem_type = ' ') then 'SEI'
else b.mem_type end
....

If your users have a naming convention that's different from that used by SQL Server you can use that as a filter.

I'm a HUGE Crichton fan...but I'm with the poster who voted for classics like "Brave New World"...still love rereading oldies like "1984", "Invisible Man" etc..

For a restful "lounging in the...

Just this morning I was reading Joel's first BillG review...interesting glimpse of the great man...and one whom Joel calls a "real, actual programmer"...

All the news items say that "change...

I puzzled over that one for so long and now all is clear - the way I read it I thought the Canadian licenses have mugshots of people other than...

TIAT indeed!!!

Read the editorial - if it interests you and you have something to contribute - respond - if it doesn't interest you - MOVE ON!!!

As for learning about technology...

Obfuscate is a difficult enough word without having to obfusTIcate it further..

Finally I get the time to goof off on a Friday...didn't get past the first page...

You're in windowless room with 12 inch thick solid steel walls and the door...

It'd be really difficult to figure out why you're getting multiple rows unless you post sample data from each of the tables etc..

You'd trace this quicker if you just ran...

Hear! Hear!

I have a home-office as well & here's what I save on:

1) Time

2) Gas

3) Auto maintenance

4) Laundry

5) I can take time away for medical appmts., house settlements et al...

select usr, max(dt) from test

group by usr