Thanks Gila...talk about much improved search results when you know what the actual term is...

mw112009 (5/11/2015)

---

What I really need is to find the entries that have the word LVAD but on either side there should be a space chartacters.

In other words I don't want...

Have you looked into setting up a CMS (Central Management Server)?

Cursor's and Dynamic SQL aren't bad per se but rather can cause issues when not executed properly. Try to...

You have to escape it by adding another single quote.

'James O''Neil'

You can test it out.

DECLARE @test-2 NVARCHAR(20)

SET @test-2 = 'James O''Neil'

SELECT @test-2

This is how I did it

DECLARE @testdata TABLE (id int, date datetime, Amount int);

DECLARE @testdates TABLE (date datetime);

INSERT INTO @testdata (Id, Date, Amount)

SELECT 1, '1/6/2014' , 21 UNION ALL

SELECT 1...

As Sean has mentioned some sample data would be very helpful here. That being said I have a funny feeling you are getting the same data multiple times because...

You're right about that one...I've been stung by...

This would probably work also but...

Alan's answer works and is nice and clean. I figured I'd add my take since I was already looking into it. Often there are more than a few...

SELECT REPLACE(Address2,'P.O. Box','Post Office Box') AS Address2 FROM CLAddress

https://msdn.microsoft.com/en-CA/library/ms186862(v=sql.100).aspx

better yet...

https://msdn.microsoft.com/en-us/library/ms181984(v=sql.100).aspx

I realize you may not have known about the REPLACE function but the previous posters were trying to push you in...

Just throwing it out there but why do they have to write back to the same DB they read from? I'd have them pull from the read only unless...

I rigged up an example for you before...

I have to give you a thumbs up for providing the sample data and code.

The bad news is your table structure is what's killing you. I'll admit I obviously...

I just...

Ok so if you only care about locating Package Numbers that have a CDI but does not have a POD this should work.

SELECT

Field6 AS PackageNumber,

MAX(CASE WHEN Field4 = 'COLLECTION/DELIVERY INSTRUCTION'...