Lynn Pettis (5/14/2009)

---

Bob Hovious (5/14/2009)

---

Calm you must be, Lynn. Dwell on them you should not.

For though their numbers are legion they are not strong...

Lynn Pettis (5/14/2009)

---

The sun has set in the deep desert and lone figure sits quietly meditating next to a small camp fire. While sitting there, he simply cannot believe...

At least I can say that my signing voice...

Me thinks Bob's gone off the deep end!

Bob, relax,...

At least he didn't say Senior SQL DBA

Please try this and tell me what you get.

declare @CustomerRef as varchar(50)

set @CustomerRef = '00000012345678900'

select REPLACE(LTRIM(REPLACE(@CustomerRef,'0',' ')), ' ','0')

Add the missing space between the single quotes...

There should be a space between each pair of single quotes. The space is missing from the logic you pasted.

You're welcome and keep us posted on how it works out.

Good luck.

Samuel took the words out of my mouth, or should I say the keystrokes out of my fingers.

We've done that here with DTS. One thing that we do to...

You might want to try and capture the writes using Profiler. You nay find that it's doinf something else at the same time.

Just my 3 cents worth

Jack Corbett (5/13/2009)

---

Luke L (5/13/2009)

---

I've always had decent luck with Dell laptops. they just seem to consistently beat out IBM And HP on price for the same hardware. ...

Even if it had a...

How many point will I get if I post that video of Bob playing the banjo and signing his song?

😀

Can we trap Bob in the transporter buffer next time?