I would still stick to char(10) and maybe consider a date column on the table so you know when you loaded the specific numbers into your system (in case there...

I do a lot of work with phone number filtering on a daily basis. The structure for every column I have throughout the system that holds...

So, I checked the BOL... it seems like the ELSE clause is required, even if left empty...

"ELSE else_result_expression

Is the expression returned if no comparison operation evaluates to...

One other option that made my life MUCH easier: I had the opportunity to follow the concepts of spreading files around the server. In other words,...

Jeff, that's likely the case. I have been noticing a correlation between by local user app crashing and these processes sitting there... In rechecking my app,...

I don't think it's specific to that application. I have two different main applications running that my local users use, and both applications occasionally have processes...

Hmm... well, lets see if we get any toher responses before we decide its normal

This is an easy one... I have had this problem before, and essentially it is because you don't have some kind of unique identifier on the record. ...

How about:

SELECT <rows>, COALESCE(<nullcolumn>, 'ZZZZ') AS <nullcolumn>

FROM <table>

ORDER BY <nullcolumn> ASC

Maybe I'm being overly simplistic here or this has already been tried, but why not something like this:

SELECT SUM(CurrencyColumn) AS DollarSum

WHERE CurrencyColumn NOT NULL

Point taken. And I'm not offended... no autopsy, no foul.

Yeah, thanks, Dalec for your insight. I wasn't shifting the blame to the NetAdmin (did I hit a nerve, though?), I was implying that I made...

Actually, I was assured by the NetAdmin that my server was being backed up (the partitions that hold my MDF's and LDF's) as part of the backup...

Steve,

I'm not offended, and I use the forums daily. That won't stop.

There are a few billion people on the planet, and all have different opinons, and...

As I saw in another posting set, the data guys outlined what they really wanted, and the people that would fit with that group likely responded. ...