p.s. SimonSabin has published a custom taskpad report on his blog at

http://sqlblogcasts.com/blogs/simons/archive/2006/11/23/Taskpad-view-version2.aspx

I belive it was changed in SP2.

Right click on the database,...

Phew! Jeff 😀

Thought you were trying to poke the...

OK. Maybe there are trailing non printable chars as well, should have thought of that :blush:.

Try

LIKE '%WDT%'

You need to do

LIKE '%WDT'

not

LIKE 'WDT%'

And this should correct the data....

UPDATE #tablename

SET colname = STUFF(colname,1,1,'')

WHERE colname LIKE '%WDT'

AND colname <> 'WDT'

I would do the following to find the offending values

SELECT colname,CAST(colname as varbinary(5))

FROM tablename

WHERE colname LIKE '%WDT'

AND colname <> 'WDT'

Good article, as usual, Jeff 🙂

You sure know how create these long threads 😉

p.s. Keep banging that drum, they'll either get it or go deaf :hehe:

SELECT j.[name],

CAST(STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' +

STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime) AS [LastRun],

CASE jh.run_status WHEN 0 THEN 'Failed'

...

You need to match your data against a dataset of 24 hours, something like this

SELECT DATEPART(Year,a.dev_time) as [Year],

DATEPART(Month,a.dev_time) as [Month],

DATEPART(Day,a.dev_time) as [Day],

n.Number AS [Hour],

COUNT(a.tdm_msg) AS [Total_Incoming_Vehicles]...

Hear, hear. 🙂

But I think we all owe thanks to folks like Jeff...

Jeff Moden (11/15/2008)

---

I got it right but this is a really bad question for people who are still stuck with SQL Server 2000. These types of questions should probably...

Ouch! :pinch:

Wayne West (10/29/2008)

---

Huh, somehow I never noticed that in the documentation about Len() ignoring trailing spaces. Then again, chances are that I never opened BOL for Len() and just...

Wayne West (10/16/2008)

---

Hey, Gary. I just worked on cleaning up a big address table, talk about fun! Anyway, how about something like this:

select left(Address, charindex(' ', Address) -...