It's taken the right part of the field minus 47 characters (the width of the text you want removed)

I'm about 98% sure this is correct, someone will correct me if I'm wrong here. 😀

Provided you can do this during a maintenance window, to limit activity, you can ....

1....

You can just use the update part below, but the rest is there to show you that it works.

DECLARE @sampleTable TABLE (pictureURL VARCHAR(100))

INSERT @sampleTable

SELECT '~/products/art-frame-direct/accessories/baskets/10484803.jpg'

UNION ALL

SELECT '~/products/art-frame-direct/accessories/baskets/10484873.jpg'

UNION ALL

SELECT '~/products/art-frame-direct/accessories/baskets/88884873.jpg'

UNION ALL

SELECT...

Well, that's a pretty wide open question. In the example you provided, it could be re-written as ...

Create Procedure dbo.usp_Procedure1

@CallID int = Null

AS

SELECT CallID, Call Desc

FROM dbo.CallLog

WHERE CallID Between COALESCE(@CallID,...

I can no longer contain myself. I must say that I do enjoy seeing the determination of each side in proving their correctness.

Now if you would, pardon me whilst...

if it's just the parenthisis, space and hypen that your wanting to remove, then ....

SELECT

REPLACE(

REPLACE(

...

OR 1,073,741,823 for NVARCHAR + 2 Bytes for the length.

That would be 2,147,483,646 characters + 2 bytes for the length.

2 Gig in '05

Yes Jeff, come to the dark side!...

LOL, the search box in the upper right hand corner. Even though it say's Google, it's customized for this site. :hehe:

Well it's about time !...

Read up on IDENTITY Columns. you'll find your answer there.

I've had to use it most recently when we...

At first glance I was going to say use a numbers or tally table. Do a search on this site and you'll find a couple of good articles on it.

But...