Dang! Not only did Eugene beat me, he corrected the rest. His code is correct.

I think what OP is looking for is double single-quotes as opposed to just single quotes or double quotes

''*''

instead of

'*'

or

"*"

Produces the following result:

[PERFORMINGPROVIDERID]=COALESCE(NULLIF([PERFORMINGPROVIDERID],'),NULLIF([PERFORMINGPROVIDERNPI],'),NULLIF([BILLINGPROVIDERNPI],'),REPLICATE('*', 10))

Is that correct?

Adi Cohn-120898 (8/14/2012)

---

Few years ago I've had very strange interview. I was asked all kind of strange questions that had nothing to do with my ability to work as...

Extended Events, Profiler traces and querying the DMVs are all probably better options but I just wanted to mention for all the noobs out there that there is also a...

I got a job at a marketing company in Soho, London. They didn't mention it in the interview but they expected me to handle any network issues too! I got...

You could have the best interview in the world, they can show you amazing things but it could be a simple illusion (been there) or it could be the other...

I think it is straightforward from the doc.

You need something like this:

J:\testfile.dat 2 0x1 1000

K:\testfile.dat 2 0x2 1000

L:\testfile.dat 2 0x3 1000

M:\testfile.dat 2 0x4 1000

I'm going to have to disagree. Interviews and first dates are very similar. In order to avoid wasting everyone's time...

I feel like maybe OP misunderstood the requirement? Maybe the request...

Had I seen this thread without the already great replies my initial instinct would still be the same as yours. Take the full backup first. As others have...

This looks neat but I have 1 question. Please pardon my ignorance as I've never used a 3rd party Task object in SSIS. Say I develop a package...

That looks more like an IntelliSense type product that happens to work with several editors including Notepad++. Not sure if that's what the OP had in mind or not....

I think what you mean is if you have a data set like this:

CREATE TABLE USERS ( TYPEID INT,USERNAME VARCHAR(30),)

INSERT VALUES (1,'JSMITH')

INSERT VALUES (2,'JDOE')

INSERT VALUES (1,'ASMITH')

and you do something like...

This is how it's worked since at least SQL Server 2000. I have worked with SQL Server 7 but I never did any installs in those days so I'm...

Thank you Tom. Now that I've had a chance to get over the initial shock I can see your response is more in line with what I think the...