GSquared (4/21/2008)

---

Okay, I have to ask if this is being over-complicated. Why not just:

declare @Test varchar(100)

select @test = '1

2

3'

select @test = replace(@test, '

', '')

select @test

That works for me. ...

GSquared (4/21/2008)

---

Access forms can directly connect to a table-value function. You don't need the view in between. You can even put the input parameters in the form definition.

In...

The big question in my mind is why a datetime parameter is being passed as nvarchar.... You REALLY don't want to do that. Bind the datetime parameter to...

GSquared (4/21/2008)

---

The regex won if the pattern had text in between separate numbers, and you wanted that simply removed, the last function I proposed won if not.

The example I used...

Ian Massi (4/18/2008)

---

I am quite grateful to have won this, especially since I rarely win anything. It's nice to know that there are like-minded people who deal with the...

Let me get this straight: to paraphrase this using terms Jeff can associate with, the exceptional DBA lives by the following motto:

"Best defense - no be...

If I remember correctly - the duration is expressed in some funky notation ("integer" version of HHMMSS), so in order to add them together - you'd have to convert them...

ALZDBA (4/18/2008)

---

well ... maybe the are ...

try to add an "order by 1,2,3 " at the sqlserver side as wel as at the access side.

Maybe then you'll see the data...

oops...:)

What can I say - Friday it is, hmm? (Yoda-style?)

By the way - for better or worse - if you...

hmm. It seems to at leaqst remove some of them for me.

Another, more reliable way - CLR and a Regex construct. That would give you:

set @t=dbo.regexreplace(@t,'(\r)+',char(13)+char(10)) -- the...

Ivanl - Could you post the SQL from both what you do in SQL Server and in Access? something's missing - but we can't tell without some specifics....

...and in that case your WHERE clause would make no sense (since all of the columns you want updated are already equal to the values you want to set them...

I'm not sure what you're asking. If you have a dual-homed setup, then referring to devices by their Private address will tell the machine to use the private network....

Chris Gierlack (4/18/2008)

---

Suppose I want to remove unnecessary carriage returns from a varchar without removing the necessary ones....

For example,

declare @t varchar(max)

set @t = 'test return

test return2

'

set @t = replace(@t, char(10)...

Mark -

Barry and I kind of stumbled on that the other day. Take a look over here...

http://www.sqlservercentral.com/Forums/FindPost483865.aspx

You essentially have to "take the namespace on head-on", meaning declare it and...