An excellent question and one which has just diverted me from my...

From BOL:

DT_STR

A null-terminated ANSI/MBCS character string with a...

c.jowett (5/16/2011)

---

Thanks, I will try that. Just one thing is confusing me though. If the connection manager has a valid user name and password specified in it, why...

The proposed solution does use sets - at least in the background.

Yeah, I agree - and there are plenty of RegEx examples available which would mean that it wouldn't take long to work out, even if you don't know.

But if the...

Have you tried that? Something like (untested):

POLICY_ZIP >= "A0000" && POLICY_ZIP <= "ZZZZZ" ? "00000" :...

Damn right. I really feel like I'm doing valuable work when I'm chest deep in obtuse XML hierarchies.

Perhaps I should withdraw the post and take a few minutes to reflect...

Saying things like

is not very helpful to people who are trying to understand your requirements...

Presumably, there is other data on the lines with no dates which you want to keep? If so, you can't use Koen's solutions, as they'll discard the entire row.

From the...

kkupchyk 4137 (5/10/2011)

---

“Despite my past affair with Crystal Reports, I have to report that I’ve thrown over my loyalty to Stonefield Query. The simplicity and depth of the program make...

Not that I can think of, though there is more than one way of doing it:

1) In the SQL source.

This is probably where I would do it.

2) In SSIS -...

One way or another, you're going to have to do a replace somewhere, as there is no global option to tell Excel to display blank cells as NULL, to my...

I think the OP merely wants a script which lists permissions, rather than sets them, though it's not the clearest post of the day 🙂

Grrr, pipped at the post by Lowell 🙂

The system is defaulting to integer arithmetic.

Try dividing by 1024.0 to force real precision.